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.