Adding 30 or 60 days to a date based on another Cell Value

Luke Rowan

Greetings,

I am trying to calculate either 30, or 60 days from a date, depending on the value of another cell. Example:

Cell 1: Date

Cell 2: $ Value of less than 50k or $ Value of $50k and up

Cell 3: Date plus 30 or 60 days, depending on the value of Cell 2.

Any ideas?

Thanks!

Find more posts tagged with

Formulas

Services

Project Management

Comments

Mike Wilday

Try this formula.

=IF(ISBLANK(Value1), "Please Enter Value", IF(ISBLANK(Date1),"Please Enter Date",IF(Value1>= 50000, Date1 + 60, IF(Value1< 50000, Date1 + 30

If your column names contain spaces use brackets like this... IF(ISblank([Value Name]1),
These are based on row 1 - adjust the number to adjust which row you are pulling from.
I left off the closing brackets as Smartsheets will close them all for you.

Luke Rowan

I made an attempt, but it's coming back unparseable. I've included a screenshot, but here is the string I used.

=IF(ISBLANK([Project Value $]1), "Please Enter Value", IF(ISBLANK([Commissioning Date]1),"Please Enter Date",IF([Project Value $]1>= 50000, [Commissioning Date]1 + 60, IF([Project Value]1< 50000, [Commissioning Date]1 + 30)

Thanks for your help by the way!

SmartSheet Clip.png

Mike Wilday

Delete the closing parenthesis... Let Smartsheets close them all for you and see what that does. That should do the trick...

If that doesn't work, make sure there are 4 closing parenthesis at the end. ))))

J. Craig Williams

You can also get by without the 4th IF

=IF(ISBLANK(Value1), "Please Enter Value", IF(ISBLANK(Date1),"Please Enter Date",IF(Value1>= 50000, Date1 + 60, Date1 + 30)))

Craig