If not blank than Formula question

Options
✭✭✭✭

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:

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"))))))))))))

• ✭✭✭✭✭✭
Options

You could use an IF statement.

=IF([Column Name]@row <> "", original_formula)

• ✭✭✭✭✭✭
Options

You could use an IF statement.

=IF([Column Name]@row <> "", original_formula)

• ✭✭✭✭✭✭
Options

Another approach could be: IFERROR(original_formula,"")

Dale

• ✭✭✭✭
edited 04/28/21
Options

Thank you Paul!

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭
edited 04/28/21
Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!