Using the IF formula

#1

Hi. I have troubles implementing this logic in my table:

  1. 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…
  2. 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?
0 Likes