it would be great if we could set a day and time to either enable or disable a form. We want to cut off form entries as of midnight, and I will have to go in a manually do that.
Sign in to see the current vote count, add your own vote, or leave a comment.
In the meantime…
Add a header to the form that includes a note about submissions being closed.
Add a new date field that is hidden and set the default value to be the date you want to stop allowing submissions.
Use three field logic rules based on this date.
First: If the date is after today, show the fields for submission.
Second: If the date is today, show the fields for submission.
Third: If the date is before today, only show the header.
If only the header is shown, no additional fields can be filled in. With no fields filled it, users cannot submit new entries.
While it technically doesn't deactivate the form, it does remove the ability to submit the form once the date is reached.
Brilliant! Can’t believe I hadn’t thought of that.
Thank you!
Happy to help. 👍️
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
It would be nice to be able to deactivate all automations at one time when I need to work on a sheet. Then to be able to activate all of them at one time when I am finished. One of my sheets has 48 automations. It is extremely time consuming to deactivate them one at a time. Thanks! Freda
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
