How to Enter an estimated date of completion formula

Bryan Carnegie

Good Afternoon,

I am trying to enter in a estimated date of completion formula into my smartsheet 20 days after the row (Today's Date) has been entered. Can someone please assist me? This is the formula I am using at the moment and I'm unsure of where I am going wrong.

=([Today's Date]:[Today's Date])@row + 20

Andrée Starå

Hi Bryan,

Try this.

=[Today's Date]@row + 20

Did it work?

I hope that helps!

Happy New Year!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bryan Carnegie

It will work however, it will not do the whole column just a row at a time.

Andrée Starå

Not sure I follow!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Wright

Hello,

I have a similar question, I am trying to write formula to calculate difference in BASELINE END DATE to actual END DATE compensating for RAIN DAYS which posted in a duration column

Wright

Hello,

I have a similar question, I am trying to write formula to calculate difference in BASELINE END DATE to actual END DATE =[Baseline End]58 - [End Date]58. Now I want to compensate for RAIN DAYS but receive UNPARSEABLE

Thanks, Gary

Paul Newcome

@Wright I have commented on your original post.