Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to automate recurring dates
I have a sheet where we are required to log certain inspections and tasks. The frequency of the inspection and task differs for each ie quarterly, six monthly, annually etc. The frequency is dependant on the first date ie 15 June then the next inspection for 3 months is 15 September (ie the dates are not fixed). We need to keep the dates of the previous inspections as part of our audit process.
As this sheet will be used across some 60 locations I need to automate the process so when different users tick the checkbox that the inspection or task has been done, the next date (based upon the frequency in that row) will automatically appear without having the user to constantly adding the next date etc.
How can I do this?
Also, how can I determine when the next inspection or task date is due across all sites and all tasks easily?