How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?

Y M ✭✭✭
edited 12/09/19 in Formulas and Functions


I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the collaborators receive a blank form to update (to prevent confusion).

Please advise? I am not sure if I am supposed to use a formula or if there's another way I can have a clean sheet form for the collaborators to fill.

The next step would be ideally be, "IF the collaborators DO NOT fill the form sheet by a certain date, then we will assume the collaborators are BUSY, and their designated rows would appear as busy." So if they are NOT busy then they are required to update their designated row on the form.

Please advise?



Consultants Weekly Availability Screenshot_Update Requests 1.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!