Referencing a not blank cell of 5 cells.

08/31/20
Accepted

Hi,

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

Answers

  • Fantastic. It worked. Thank you so much!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

Sign In or Register to comment.