Welcome!

Nested IF - Incorrect Argument

Hoping someone may be able to spot my error. Attempting to return 1 of 5 statuses (Complete, Not Started, Late, Pending, or In Progress). I think the challenge is with the Pending status, where I am trying to flag a due date within 7 days of today.

=IF([Percentage Complete]1 = 1, "Complete", IF([Due Date]1 < TODAY(), "Late", IF([Start Date]1 > TODAY(), "Not Started", IF(AND([Due Date]1 > TODAY(), TODAY() > [Due Date]1 - 7, "Pending", "In Progress")))))

Thanks!

Find more posts tagged with

Comments

sean59916

It's almost right - I used the formula:

=IF([Percentage Complete]1 = 1, "Complete", IF([Due Date]1 < TODAY(), "Late", IF([Start Date]1 > TODAY(), "Not Started", IF([Due Date]1 <= TODAY() + 7, "Pending", "In Progress"))))

See the screenshot - I hope this helps?

Sean

loeschb

Excellent. Thanks, Sean.

Paul Newcome

To add on...

The problem with your original formula is that you did not close your AND statement.

=IF([Percentage Complete]1 = 1, "Complete", IF([Due Date]1 < TODAY(), "Late", IF([Start Date]1 > TODAY(), "Not Started",

IF(

AND([Due Date]1 > TODAY(), TODAY() > [Due Date]1 - 7),

"Pending", "In Progress"))))

Notice I added a closing parenthesis after the 7 and removed one from the end of the formula.

Sign in to join the conversation!

Quick Links

Trending discussions

I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Need Help w/ Report View - Nothing Is Showing
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…