Creating a 2nd date calculated from initial date

Added data in row with a created date I want to automate an expected close date 30 days from created date.However the expected close date could move and I want to be able to change that days adding on days until actual becomes yesterday.

of this I want to run forcasting into months and length of sell cycle.

I have read that the first part works with =[Created Date] +30 , but I have not been able to make that formula give any outcome except errors and I have tried a number of variations based on comments in help and community.

I feel if I can crack this I can then at least move on to the next issue.

Any suggestions

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi,

You are missing which cell the formula should look at. With the @row function, you don't need to think about which cell number to reference as long as you want to reference the same row.

Try this.

=Created@row + 30

Did it work?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help with the next steps. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Pepenav

Sorry for delay in reply I have been all over the shop trying to get different things to work. for this issue I created an additional column called number of days and created a trigger of that, but I would like to come back to your simpler solution when I have time to go back over things

Andrée Starå

No worries!

Let me know when it's a good time and if you need any help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
Automation not triggering when % Complete shows '100% instead of 100%
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…