Sign in to join the conversation:
Hello,
I have created a form and have a column named "Date Item is Needed" which is a date type column. However, the requestor needs to allow at least 10 days from the actual day. Is there a way to always black out those 10 first days?
Thanks!
The best way would be to have a separate column in your sheet that adds 10 days to the submitted column. Then in the rest of your solution, just reference the new column.
There is no way to restrict those dates within the form. You wold have to look into a 3rd party form such as Google Forms (easy to use and integrates into SS very easily) or use help text on the form along with an automated Update Request to instruct the submitter to select a date within the appropriate range.
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…
