Discussion List
MAX COLLECT for blank cells
Hello all, we use a Smartsheet form for students in our internship program to submit their weekly hours worked for our instructors to track. Because the form creates a new row for each submission, I created a rollup sheet using MAX(COLLECT() to show all submissions on a single row to make it easier for our instructors.…
Select if multiple update request are acceptable.
Why not have a selection for multiple update request OK? We have sheets that get updated when information becomes available. But once you use the link and submit button for Update Request, you can not use it again. Our teams would like to use the Open request and submit multiple times for updates when they come available.
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
View Cell History in WorkApps
We should be able to view cell history withing WorkApps. I'm very surprised this isn't currently possible!
Remove or Suppress Blank Rows in Report
Hello. I have a report that is displaying 15-20 rows of data (will never exceed 25 rows). The problem is that the report appears to default to showing 50 rows regardless of the data. As a result, in the current state, there will always be between 25 to 35 blank rows on this report. I am looking to use this report on a…
Group Rows in Sheet, not just in Report
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
Fully customized automated emails
Is there a way to better customize automated emails? Backstory: We have an intake form where our users are able to enter a ticket for our team. We want to provide some transparency and a view to that request - status, priority, etc - without giving them access to the sheet itself because we have a ton of working columns…
Flagging events that share dates
I'm struggling to come up with a way to alert if any other events in the sheet share any dates in common. I'd like to use the "Other Events?" checkbox column to flag if matches are found. And, if possible from there, add another column that lists all the events that have any matches. In the example screenshot, the Dates…
How do I stop people from exported my smartsheet?
When they have commenter or viewer access? I do not want anyone downloading my smartsheet only have access to veiw only or comment. What can I do?
C# datatable to upload to a smartsheet API
Is there a quick way to upload a C# datatable object into a smartsheet sheet through API without doing it cell by cell? Thank you!