Can I combine an =if(and formula with a Max formula?
=IF(AND([VALUE 1]@ROW = "YES", [VALUE 2]@ROW = [VALUE 3]@ROW), "TBD", MAX([VALUE 2]@ROW:[VALUE 3]@ROW))
IF value 1 is yes AND IF value 2 = value 3 THEN enter tbd ELSE return the MAX value of value 2 and value 3. My formula returns a #invalid column value.
Best Answer

The column your formula is in will need to be a Date type column and it probably isn't currently. I got the same error as you with the formula column as Text/Number but it worked as a Date type column.
Answers

What type of columns are Value 1, Value 2, Value3, and the column your formula is in?

Value 1 = Text/Number, Value 2 & Value 3 = Date (restrict to date only)

The column your formula is in will need to be a Date type column and it probably isn't currently. I got the same error as you with the formula column as Text/Number but it worked as a Date type column.

Perfect  that worked. Thanks.
Help Article Resources
Categories
Check out the Formula Handbook template!