Automatic Date Setting

Charlotte Martin

Hi!

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!

error smartsheet.PNG

DKazatsky2

Hi @Charlotte Martin,

Ensure the column "Date Comprehensive Submission Due" is set to a "date" type.

Hope this helps,

Dave