I am experiencing an issue with the Smartsheet API where data from columns containing formulas are not being returned when querying a sheet. However, the same data is correctly displayed in the UI and can be accessed through reports via THE API. So I can access sheet data for formula columns via a report that points to this sheet, but I can't retrieve formula columns data when directly trying to access sheet data. The Sheets are not returning the expected data but Reports that point to the sheet work fine and all the data is returned. Below are the details of the issue:
Report Data Request: GET /2.0/reports/reportID?level=2&page=1&pageSize=500
The API response for this request includes the calculated from the formula columns.
Column Details:
Data:
Sheet Data Request: GET /2.0/sheets/sheetID?pageSize=500&page=1
The API response for this request does not include data from the formula columns, despite the UI showing the correct values in the sheet. Values and DisplayValues are 0 in the API response.
Column Details:
Data:
Is this a know issue? If you have any ideas kindly share them. I really appreciate your help.
Thank you so much.