Formula to change certains Dates

Leonie Muller · 08/14/19

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

Screenshot_2019-08-15 (8) ASIC CHECKLIST - Smartsheet com.png

Paul Newcome · 08/15/19

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 · 08/19/19

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 · 08/19/19

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

Thanks

Leonie

Paul Newcome · 08/19/19

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å · 08/27/19

Hi Leonie,

Did you get it working?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Leonie Muller · 08/27/19

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å · 09/01/19

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å · 09/16/19

Glad we got it working!

Have a fantastic week!

Best,

Andrée

Formula to change certains Dates

Comments

Help Article Resources

Categories