Help

IF Formulas to List Multiple Fields

Topic Labels: Formulas
Solved
Jump to Solution
7708 11
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Lussenho
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to create a formula that will list multiple fields that are empty, but can only get it to list a single field. It is meant to be a quick reference field to see what info is not filled out in a row.

The goal: IF {Field 1}, {Field 2}, {Field 3} are all empty, but {Field 4} is filled out, then list “Field 1, Field 2, Field 3”

Below is my attempt. It only ever lists a single field, seemingly overwriting other values that would be returned. If I introduce OR IF it breaks the formula.

IF({Film Year}=BLANK(), “Film Year”, IF({Print Source}=BLANK(), “Print Source”,IF({RT (min)}=BLANK(), “RT (min)”)))

11 Replies 11

You could have a View that Filters to show records that have any of those 5 fields empty. Even you could just show those 5 fields. If this is stupid for your case, I tried :grinning_face_with_smiling_eyes:

That is also a great idea! We have so many views in this tab though, I was trying to avoid creating another one. Thanks for the suggestion.