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.
Hi - I am trying to calculate the ratio between the number of completed requests and deferred requests in a Smartsheet, and how to display this ratio on a Smartsheet dashboard. I added the summary fields for the Completed and Deferred requests using Sheet Summary. I already created the formula to calculate the ratio for…
Hi, I'm trying to figure out how to preserve cell data BEFORE an Update Request is executed. I was hoping to find functionality that would allow me to change the value of a cell in helper column WITH the value of the cell that is going to be updated once the Update Request is sent and subsequently executed.
I am trying to run a report for all of the cells in my "Last Contact Date" column that are not linked to another cell. We have separate teams who are populating separate sheets (SS Logs) so we can link the dates back here, but until they do, we'll just see the dot indicating it's linked with a blank value. The full sheet…
