Help with date formula/automation

Options
Nicole Tellez
Nicole Tellez ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to help a user automate a current process in Smartsheet.  The information within the sheet is compliance info and each item has different regulatory rules.  Some items have monthly update requirements, while others have quarterly or annual update requirements. Right now the sheet admin goes in the sheet to see when items were last updated and changes the due date to the next month, or whenever it's due.  There is also a helper column that states the frequency of which updates are due.  This sheet has 250+ lines of compliance items. 

I was wondering if anyone new of a way to make this less complicated and create some sort of automation/formula to update the due dates based on the frequency column?  

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!