Formula to change certains Dates

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

Find more posts tagged with

Formulas

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
How can I set up recurring tasks in Smartsheet?
I need tasks that repeat (daily, weekly, monthly, yearly). Each should show a due date and a “Completed” checkbox. When I check it off, I’d like the task to log in an archive sheet with the completed date and then reset on the main sheet with a new due date and cleared checkbox. Has anyone found a simple way to do this?
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…