Nested IF Formula - Date Error

Connor

Set up a basic Nested IF that does nothing more than display the mailer round status based upon a set of dates entered. With no dates inputted the formula displays the correct value, however once I input a date it returns "INVALID OPERATION". I've attached a copy of the formula below for commentary. Appreciate the help.

 

=IF([1st Round]36 = 0, "Ready for Vet", IF([2nd Round]36 = 0, "Round 1 Sent", IF([3rd Round]36 = 0, "Round 2 Sent", IF([4th Round]36 = 0, "Round 3 Sent", IF([5th Round]36 = 0, "Round 4 Sent", "Round 5 Sent")))))

Shaine Greenwood

Hello Connor—it appears that your formula is set to check values in a referenced column to see if they equal 0, which is something that Smartsheet won't recognize as a comparable value to a date. Smartsheet doesn't have a way to check or compare date values to numeric values directly, so you may need to adapt your formula with that in mind.

 

I'd recommend checking out our date formulas to see if there's a way you can convert the date into a numeric value, then see if that value is equal to 0 or another number: http://help.smartsheet.com/articles/775363-using-formulas#date