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:

=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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!