Hi. I have troubles implementing this logic in my table:
- There are incomplete items with missing values, for example: some items have Phone#, some have email addresses filled; others have DOB, but missing the Last name…
- I want a formula attribute that shows a summary of what info is missing, e.g. a column that says: '‘no DOB, no phone’ for one item, but ‘no Last name, no email’ for another item, based on the filled / blank cells in the table.
Any ideas how this can be acheived?