I have a report from a smart sheet. I want to have a hyperlink to be able to open the data sheet from the report, but the data sheet is not listed as a sheet when you open the hyperlink to another sheet.
For a particular project category, I'm attempting to count how many times the "Project Status" column is either a blank cell or not "green" (aka complete). These projects will be marked as "Active" on my stats sheet.
Here's the formula that I have thus far and I'm receiving an Invalid Operation
I am hitting the users endpoint(https://api.smartsheet.com/2.0/users) to get all of our user information. I am trying to find out inactive users based on last login date. The API call doesn't return me the last login information for any user. I can see this information when I export the csv of the