If this column is certain text, use this column plus this many days

Thi Nguyen

Hello, I'm trying to create a formula showing if column A is the word On then use column B date + 75 days, if column A is the word Off, then use column B date + 120 days. All the formulas I'm typing in keeps showing up as #UNPARSEABLE. Help please!!!

Paul Newcome

Try something like this...

=[Column B]@row + IF([Column A]@row = "On", 75, 120)

Paul Newcome

Try something like this...

=[Column B]@row + IF([Column A]@row = "On", 75, 120)

Thi Nguyen

Thanks Paul! Unfortunately that didn't work either :(

I wonder if it has anything with my columns setting. I put the "on" "off" as drop down single select. And the other two columns are set as dates only

Paul Newcome

Are you getting an error or an incorrect result?

Thi Nguyen

#INVALID COLUMN VALUE

Paul Newcome

Double check to make sure that both columns are set to be date type columns in the column properties.

Exactly how is [Column B] populated?

Thi Nguyen

Column A is a drop down list with either on or off. Column B is set as a date format, so anyone can go in an insert a date. Which should populate Column C into another date.

What I want it to do: Column A: On -> Column B: 02/24/21 -> Column C: 02/24/21 + 75 days

Column A: Off -> Column B: 02/24/21 -> Column C: 02/24/21 + 120 days

Paul Newcome

Yes. If columns b and c are both formatted as dates and column b contains date values, then you should be able to use

=[Column B]@row + IF([Column A]@row = "On", 75, 120)

in column c.