I would like to send an alert to the person "assinged" to the appropriate row the day after a "Due Date" IF a "Status" column has/doesn't have a value(s). For example, "Send 'Assigned To' and email re…
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Tha…
Hello, I am trying to create a formula for a column that will determine the number of days remaining from an expiration date. Furthermore, if possible, I would like a status indicator (green, yellow o…
Hello all, We have been using SmartSheet mostly for data tracking on requests and proposals. However, our current project management system falls well short of our needs. I am in the process of settin…
I want to use a web form to populate Smartsheet. I have a field called "Section Number" that requires a text value. It is a 3 character field that will contain numerical characters like "001" or "020"…
There is a restriction on the standard Project sheet template currently: if using the provided "Start" and "Finish" fields, users are not allowed to add a value to a row that has children - instead, t…
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notif…
I am using update requests quite a lot, but they are not for recurrent type activities. I would like to think they would be recieved and acted on, so I don't set up reminders. My problem is that recip…
I'm a new Smartsheet user and I need to remove 7 licensed users from our account and transfer ownership of about 200 sheets. I've downloaded the user access summary sheet and I see the name of the she…