If not blank than Formula question
I have a few formulas that I only want to display information whtn the data source is not blank. Currrently, when the data source is blank, the destination formula says invalid, but I want the destination to be blank. Are there any qualifiers that say " If x column is not blank, than apply formula"?
These are the formulas in question. Let me know if you have any ideas.
In example one, I want the month the chart was received to be displayed, and the cell to remain blank if the Chrt Review column is blank.
1:
=MONTH([Chart Review Received]@row)
In example two, I want the Month to be displayed only if the Month Number column has a value in it, but to remain blank if Month Number is blank.
2:
=IF([Month Number Chart Review]@row = 1, "aJanuary", IF([Month Number Chart Review]@row = 2, "bFebruary", IF([Month Number Chart Review]@row = 3, "cMarch", IF([Month Number Chart Review]@row = 4, "dApril", IF([Month Number Chart Review]@row = 5, "eMay", IF([Month Number Chart Review]@row = 6, "fJune", IF([Month Number Chart Review]@row = 7, "gJuly", IF([Month Number Chart Review]@row = 8, "hAugust", IF([Month Number Chart Review]@row = 9, "iSeptember", IF([Month Number Chart Review]@row = 10, "jOctober", IF([Month Number Chart Review]@row = 11, "kNovember", IF([Month Number Chart Review]@row = 12, "lDecember"))))))))))))
Best Answer
-
You could use an IF statement.
=IF([Column Name]@row <> "", original_formula)
Answers
-
You could use an IF statement.
=IF([Column Name]@row <> "", original_formula)
-
Another approach could be: IFERROR(original_formula,"")
Dale
-
Thank you Paul!
-
Happy to help. 👍️
*DISCLAIMER: I have no proof of anything. The below is just my way of thinking and personal preference.
I feel like going the route I went with the IF the cell is not blank might be a little more efficient on the back-end because it first evaluates a single cell and will stop as soon as it realizes it is blank/only runs the full formula on rows where that cell is not blank whereas going the route of the IFERROR means it is running the full formula on every single row all the time.
Again... I have never done any testing on how much more efficient (if any) it is. It is just the reasoning behind why I used the IF as opposed to the IFERROR.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!