Nested IF Statement What do I have incorrect

Hollie Green

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

Sameer K

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")
            )
        )
    ) 

Sameer K

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

Thank you! That fixed it!