Nested IF Statement What do I have incorrect

=IF(Result@row = "", "", IF(Result@row > DATE(TODAY(-30)), "New", IF(Result@row > DATE(TODAY(-60)), "Developing", IF(Result@row > DATE(TODAY(-90)), "Contributing", "Experienced"))))


That is my formula and the Result@row field has Date in it on one row it is giving me an #INCORRECT ARGUMENT SET error. On another row it is giving me an #INVALID OPERATION error.

Both of the results cells being referenced have a different formula that returns a date. I have the column set to Date only restriction and the sheet they are referencing to get the date is also set to Date only columns.

Best Answer

  • Sameer K
    Sameer K ✭✭✭✭
    Answer ✓

    Assumption: "Result" column in your sheet is Date type

    You do not need to convert TODAY function again into Date type as the TODAY function return Date type by itself. Remove the DATE function conversion around all usages of TODAY function and you should be good. (Btw, syntax for using DATE function is incorrect too.

    Try this:

    =IF(Result@row = "", "", 
            IF(Result@row > TODAY(-30), "New", 
                IF(Result@row > TODAY(-60), "Developing", 
                    IF(Result@row > TODAY(-90), "Contributing", "Experienced")
                )
            )
        ) 
    

Answers

  • Sameer K
    Sameer K ✭✭✭✭
    Answer ✓

    Assumption: "Result" column in your sheet is Date type

    You do not need to convert TODAY function again into Date type as the TODAY function return Date type by itself. Remove the DATE function conversion around all usages of TODAY function and you should be good. (Btw, syntax for using DATE function is incorrect too.

    Try this:

    =IF(Result@row = "", "", 
            IF(Result@row > TODAY(-30), "New", 
                IF(Result@row > TODAY(-60), "Developing", 
                    IF(Result@row > TODAY(-90), "Contributing", "Experienced")
                )
            )
        ) 
    
  • Hollie Green
    Hollie Green ✭✭✭✭✭

    Thank you! That fixed it!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!