Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Receiving unparseable error when selecting a field in one column and wanting a specific result in another field. This is the formula. What am I missing?
=IF([Submit for Approval]1,1[Manager Approval]1 = "Submitted")
See attached
First of all, you can't control the contents of a cell from a different cell. You need to put the formula in the cell you want the results to appear in.
In this case, try, putting the following formula in the Manager approval field.
=IF([Submit for Approval]@row, "Submitted", "Your Text Here")
If you want the field to be blank when the submit is blank then erase, "Your Text Here. Or put in a different statement for when its not submitted.
I have an end date column and want to add 30 days to that for a new column that shows due date. How do I add 30 days to a date automatically?
The dashboard previously contained 16 widgets, and I have confirmed that the widgets still exist in the backend. However, when I open the dashboard, nothing is displayed, and I am unable to enter Edit Mode or access the widgets/data sources. I have already confirmed the following: I am the owner of the dashboard and have…
Why is it so convoluted now! I eventually figured out the changes and ended up with a sheet that Smartsheet completely reorganised the rows and the sheet is now useless to me as it is not in a logical order for me to easily restore to its original layout. This is not an "improvement"! It was far easier to upload data…
