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

Options

 =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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!