Formula: Start date + 1/2... days

Elizabeth · 06/24/20

Hello community,

I am trying to add a formula for the following:

The date in red is the start date (DATE1). The dates below should be programmed like DATE1 + 1day, DATE1 +2days etc. I tried different formulas I found in the Learning Center but for some reason it didn't work...

Thank you for your help!

Elizabeth

Andrée Starå · 06/25/20

Hi @Elizabeth

It's not working because you can't use formulas in the date columns you've specified in the project settings when Dependencies are enabled.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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

Paul Newcome · 06/25/20

Yep. That would be it. You have your dependencies turned on, and formulas can't be used in those columns.

Paul Newcome · 06/24/20

You should be able to use

=Date1 + 1

Then dragfill down.

Elizabeth · 06/24/20

Thank you for your quick reply!

Hmm for some reason that didn't work... I thought it is because I have two dates in one row (start and end date) so I changed the formula like this: =[Start Date]158 +1 but it still doesn't work (158 = row number).

Any idea why that is?

Chris Rea · 06/24/20

https://community.smartsheet.com/discussion/comment/254628#Comment_254628

make sure you're column properties are set to "date" rather than "text/number"

I input 3/8/20 for row 1 of both "start date" and "end date".

Start date column is using "date" properties.

formula for 2nd row: =[Start Date]1 + 1

next: =[Start Date]1 + 15

then: =[Start Date]1 + 60

finally: =[Start Date]1 + 90

The column properties are "text/number" for "End Date" and I used the same formula style then you can see that it's a jumbled mess of nothing useful.

Paul Newcome · 06/24/20

My first thought would be checking to ensure the column is in fact a date type column. If that doesn't fix it, what exactly do you mean by it isn't working? Are you getting an error or an unexpected result?

Elizabeth · 06/25/20

I tried out the formulas above in a new test sheet and there it works perfectly fine. I think for some reason it doesn't recognize the formula in my main sheet, when I type it in it just stays in there as text:

This even though the column type is set to date.

Any idea what I am doing wrong here?

Andrée Starå · 06/25/20

Hi @Elizabeth

It's not working because you can't use formulas in the date columns you've specified in the project settings when Dependencies are enabled.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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

Paul Newcome · 06/25/20

Yep. That would be it. You have your dependencies turned on, and formulas can't be used in those columns.

Elizabeth · 06/26/20

Andrée and Paul, thank you very much for your help!

Have a great day!

Elizabeth

Paul Newcome · 06/26/20

Happy to help! 👍️

Andrée Starå · 06/29/20

@Elizabeth

Happy to help!

Formula: Start date + 1/2... days

Best Answers

Answers

Categories