Formula to change certains Dates

Leonie Muller

Hi I am hoping someone could please help me.  I have attached a screen shot of three columns that will be used.

What I need is a formulas that when the date paid is entered then the company review date will change by a full year and the when the company review date changes I want the due date to change by 2mths

Thanks in advance

Paul Newcome

What are you basing your Company Review and Due dates off of? If they are manually entered, you will need to include additional columns.

Leonie Muller

Hi Paul,

 

Thanks for your time each are a date column which are manually entered.  I am really new to formulas in smartsheet.

Kind Regards

 

Leonie

Leonie Muller

I still not knowing how to do this.  If someone could help this would be amazing.

 

Thanks

 

Leonie

Paul Newcome

Because your dates are manually entered, you will need to use some additional columns for the dates that will be displayed. If you enter a formula and then manually enter a date, the formula will automatically be deleted.

Andrée Starå

Hi Leonie,

Did you get it working?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Leonie Muller

Hi Andrew,

I can’t get it to work without creating a circular reference. I got the Due Date to work but it reference backs to the Company Review Date which needs to change by a whole year when date paid is entered I’m at a loss.

Thanks for asking.

Leonie 

 

Andrée Starå

Happy to help!

Can you maybe share the sheet(s) or copies of them? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Andrée Starå

Glad we got it working!

Have a fantastic week!

Best,

Andrée