Can I combine an =if(and formula with a Max formula?

Shelly Toy

 =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.

Mike TV

@Shelly Toy

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.

Mike TV

@Shelly Toy

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

Shelly Toy

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

Mike TV

@Shelly Toy

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.

Shelly Toy

Perfect - that worked. Thanks.