If statements

I need to write an IF/Then formula for the following issue:

if a date required is greater than a date requested mark status pending, if delivery date is greater than or equal to date requested then mark status delivered

I had written it as follows:

If(date required>date requested"Pending"),If(date delivered requested,"Delivered")

I keep getting an umparesable error. I am sure I am missing something simple help would be greatly appreciated.

Cindy Bowker

Glastech Glazing Contractors

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!