Referencing a not blank cell of 5 cells.


I am trying to populate a cell with data in 1 of 5 cells that are filled from a form. For example, using form logic of the organization that is selected (column Org Name) select the site from that Org (Org 1 and site 1) Each Org has its own list of sites in its respective column.

I have tried using IF(ISBLANK(NOT( and can't seem to find the correct syntax. Wondering if this is even the correct function.

Any help would be much appreciated.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!