I’m trying to combine the information in two spreadsheet columns into a third column, which will be a reference to another table. Only one of the first two columns will have information in it at a time.
The expression I’m currently using is IF(ISNOTBLANK([Inactive Member]), [Inactive Member], [Active Member]), and it works fine in testing but returns blanks in the app itself, where the information is coming from the [Inactive Member] column. Where the information is coming from the [Active member] column it works fine.
Help?
LinkedIn
Twitter
