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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!