IF operator to display content conditionally

Another hack is to add a 3rd column that basically concatenates the first two columns. So my “concatString” column’s formula is =col1 + ' | ' + col2' and is set as the Display Column for the table. Then a bulleted list will allow you to see all the row’s attributes and reference the underlying row:

Capture

3 Likes