Find first non-empty cell
What formula can I use in the Current Email Helper column to accomplish the below Desired Outcome. I'm not using a hierarchy so I cant use CHILDREN()/PARENT() functions.
Here's the kind of logic I'm trying to follow:
- IF [Email]@row is empty
- THEN Look for the first cell above [Email]@row that has an email and return that value
- ELSE return [email protected]
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.