IF statement based on two cells
Hi there,
Having some problems nesting two IF statements. Here’s what I’d like to happen:
IF date is present in Actual Invoice Date column, then display “SENT” in Invoice Status column.
IF the checkbox the in PAID? Column is checked, then display “PAID” in the Invoice Status column.
IF there is no date present in the Actual Invoice column, then display "WAIT” in the Invoice Status column,.
These two formulas work independently , just don’t know what o companies them so the priority mentioned above takes place.
=IF(ISBLANK([Actual Invoice Date]39), "wait", "sent")
=IF([PAID?]@row = 1, "PAID")
Thanks!
Mary
Best Answer
-
Based on the formula I provided, it should not show "WAIT" if there is a date. Is the [Actual Invoice Date] column a date type or a text/number type?
Answers
-
Try this...
=IF([PAID?]@row = 1, "PAID", IF(ISDATE([Actual Invoice Date]@row), "SENT", "WAIT"))
-
Hi there! Try this:
=IF([Paid]@row = 1, "PAID", IF([Actual Invoice Date]@row>0, "Sent", "Wait")
-
Hi Paul, Thanks for the input. It almost works. It changes to PAID when the box is checked, but it displays WAIT when there is a date is present. I'd like to display SENT.
@Morgan Marquez unfortunately that didn't work. I get the UNPARSEABLE error.
Thank you both!
-
Based on the formula I provided, it should not show "WAIT" if there is a date. Is the [Actual Invoice Date] column a date type or a text/number type?
-
@Paul Newcome , with the Date type it works! My mistake.
Thanks for this! Have a great day.
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!