SUMIFS with ISBLANK, something is wrong
=SUMIFS(Amount:Amount, Unit:Unit, "Facilities Devel & Mgmt", ISBLANK(COVIDSpendingCategory:COVIDSpendingCategory), "Cell isn't blank"])
Answers
-
Taking a stab in the dark here, as I'm not sure of the context...
If the ISBLANK is referring to one cell, I'd suggest ISBLANK(COVIDSpendingCategory).
If looking across a range of cells, maybe try IF(COVIDSpendingCategory:COVIDSpendingCategory <>"", "Cell isn't blank" etc.
The way I understand it
using <>"" is like saying 'is not blank'
Similarly =" " is like saying 'is blank'
Hope this helps and that you have a great day,
Jason
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!
