Forum Discussion
TineM
1 year agoRegular Visitor
data querry error reorder
Hi, I have a create a dashboard which gets the data from smartsheet. The smartsheet get updated from time to time with different cell content or new added rows. If I recently click the refresh d...
- 1 year ago
Thanks all,
I check the column error message and found the problem. There was an error in smartsheet which I was able to fix and now it's working!
danextian
1 year agoSuper User
Hi TineM
A lot of possible reasons. It could be due to incorrect data type - text was entered for a column that's supposed to contain numbers only or date is in the wrong format - for example 1/16/24 is entered as 16/1/24 and your culture is US so 16/1 couldn't be read as a valid date. The error will usually tell you what's gone wrong.