Automatic Date Setting



I would like to automatically populate a date, based on another one.

In the column 'Approved by Committee', I have created an automation for a date to be created when the status changes in another column. This seems to work for now.

In the column: 'Date Comprehensive Submission Due', I want to create a formula that automatically populated to a date (2 months from the one approved by the committee).

Based on other discussions; I have tried the following formula =[Approved by Committee ]@row + 2 as a test but it says #INVALID COLUMN VALUE.

Thank you in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!