Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF Formulas to List Multiple Fields

Topic Labels: Formulas
Solved
Jump to Solution
8162 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.