IF Function not giving correct value!

I have a scenario where I need to capture all as per the end date and the date request by the requestor to complete the task, are completed on time. I wrote the following formula basis that.

=IFERROR(IF([Work Order Status]@row = "On Hold", 1, IF([Project End Date]@row < [Requested Date]@row, 1, IF([Project End Date]@row < [Revised Request Date]@row, 1, 0))), "")

Even though I have added IFERROR for the blank cells it is returning 1 as the value in the formulae.

Can anyone please help with this? 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!