I need away to deal with null values in a formula.
I have a simple formula that gives a score a value. However I need an addition that checks to see if the cell is blank and if so this row should also be blank. My issue is the NULL is showing up as 0 and populating a "Low" rating.
Formula:
=IF([Inherent Risk Score]@row > {Key Range 3}, "High", IF([Inherent Risk Score]@row < {Key Range 4}, "Low", "Medium"))
Answers

Hi, MJ215
You're already on the track!😀 just add it to your formula... If the cell is blank, then leave blank, else apply formula.
IF( ISBLANK( [Inherent Risk Score]@row ), LEAVE_BLANK , OTHERWISE_APPLY_FORMULA )
=
IF(ISBLANK([Inherent Risk Score]@row), "", IF([Inherent Risk Score]@row > {Key Range 3}, "High", IF([Inherent Risk Score]@row < {Key Range 4}, "Low", "Medium")))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!