I've created a report that I want users to be able to filter, but I don't want that filter to be saved (e.g. the next user who opens the report will see no filter). I've tried changing user permission…
Hi! I think my question is pretty simple. On a sheet, I have two columns. One is "Primary", and it's blank. The other is "Created" - a date/time column that auto-populates from a form. I want the prim…
I'm creating a dashboard that summarizes survey data for employees. I have a report set up where they can access their information, and the report is set to filter By Current User, so they only see th…
I'm trying to calculate the average score (1 to 5) of a column, but keep getting the DIVIDE BY ZERO message. The column with the scores is calculated via a formula from a column formatted with stars (…
Hi, I am overhauling our survey form to better fit the NSP format. The problem is, one of the questions needs to be a "on a scale of 0 to 10), but Smartsheet doesn't seem to have the ability to displa…
Forms should be able to have a scale option - like 0 to 10. The Net Promoter Score standards require this. When I do it, it's very ugly. Because we need to have this standard scale format as a questio…
Hi, I have a source sheet set up with form submissions. One of the columns is a Created Date. In the source sheet, the column is formatted how I want it displayed - e.g. 04/01/2024 8:47 PM. But when I…
I attended this year's Smartsheet Engage and there was a big announcement that Smartsheet would be increasing cell maximums in sheets at the end of the year. Any more word on that? What is the new max…
I'm getting so frustrated with a report! I want the rows grouped by deliverer (Primary column) then by category. But I need the viewer to be able to expand each group to see the details. For example, …
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Sele…