How to find the number of days to process with multiple IF(ISBLANK)
Hi! I'm trying to create a formula for the number of days to process invoices. This is my current formula that works perfect:
=IF(ISBLANK([REVISED INVOICE DATE]@row), [SENT TO PM DATE]@row - [OBTAINED INVOICE DATE]@row, [SENT TO PM DATE]@row - [REVISED INVOICE DATE]@row)
However I have since added another column that I need to add to this formula if there is a value in the cell. This is how I've currently edited the formula but it is returning incorrect argument.
=IF(OR(ISBLANK([REVISED INVOICE DATE]@row, ISBLANK([EMAILED LM FOR CLARIFICATION]@row))), "", [SENT TO PM DATE]@row - [OBTAINED INVOICE DATE]@row, [SENT TO PM DATE]@row - [REVISED INVOICE DATE]@row, [SENT TO PM DATE]@row - [EMAILED LM FOR CLARIFICATION]@row)
So I need to know how many days it has taken to process the invoice if there is not a revised date, or a emailed LM for clarification date then it will subtract "Sent to PM date - Obtained Invoice Date". If there are values in the Revised Invoice Date, and Emailed LM for Clarification date those dates need to be included in the value as well. I'm just not sure how to have a formula produce a value if there is a Revised Invoice Date AND a Emailed LM for Clarification date.
Thanks in advance!
Best Answer
-
Try this instead:
=[Sent To PM Date]@row - IF([Revised Invoice Date]@row <> "", [Revised Invoice Date]@row, IF([Obtained Invoice Date]@row <> "", [Obtained Invoice Date]@row, [Emailed LM For Clarification]@row))
Answers
-
Try this instead:
=[Sent To PM Date]@row - IF([Revised Invoice Date]@row <> "", [Revised Invoice Date]@row, IF([Obtained Invoice Date]@row <> "", [Obtained Invoice Date]@row, [Emailed LM For Clarification]@row))
-
Thank you!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!