If statements

Cindy Bowker

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

Andrée Starå

Hi @Cindy Bowker

Try something like this.

=IF([Date Requested]@row = "", "", IF([Date Required]@row > [Date Requested]@row, "Pending", IF([Date Delivered]@row >= [Date Requested]@row, "Delivered")))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Cindy Bowker

Try something like this.

=IF([Date Requested]@row = "", "", IF([Date Required]@row > [Date Requested]@row, "Pending", IF([Date Delivered]@row >= [Date Requested]@row, "Delivered")))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Cindy Bowker

Thanks you that worked great. I think I just don't work with the formulas enough to get them straight.

Cindy

Cindy Bowker

Sorry Andre, I can't seem to get it to be delivered only pending. Not to sure what to do about that.

=IF([Date Requested]@row = "", "", IF([Date Required]@row > [Date Requested]@row, "Pending", IF([Date Delivered]@row >= [Date Requested]@row, "Delivered")))

This is what I typed in, have I done something wrong and just can't see it.

Cindy

Andrée Starå

@Cindy Bowker

You're more than welcome!

Try this.

=IF([Date Requested]@row = "", "", IF([Date Delivered]@row >= [Date Requested]@row, "Delivered", IF([Date Required]@row > [Date Requested]@row, "Pending")))

Did it work better?

Cindy Bowker

now it just comes up with delivered no pending.

Andrée Starå

@Cindy Bowker

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)