Formula Question: IF Not Blank, Do "This"



I have a use case where I want to reflect "yes" in a column if a certain range of columns has text in it AND "no" in that column if that range of cells is BLANK. I tried this formula below and it is not working.

What am I missing?

=IF(ISBLANK([SALESFORCE Data Error: Late Fee % or Grace Period]1:[YARDI: Timing Charges Not Billed to Ledger]1), "No", "Yes"))

Thank you!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!