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.
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...
The image was just an example. It will actually be going through 350 fields to check if info is missing for just 5 specific fields. The purpose is to have a quick reference so a person won’t need to comb through everything to see what’s missing.
@W_V...
I will definitely use the reference link. Thank you.
I thought a visual aid would do a better job than me describing the goal. Below is an example image of what the finished product would be. I am trying to create the “What’s Missing” field. Whenever...
For the record, I’m a real novice at this. Per your instruction (as I understood it) I entered the following:
IF(AND({Film Year}=BLANK(), AND({Print Source}=BLANK(), AND({RT (min)}=BLANK()))), “FilmYear & ', ’ & PrintSource & ', ’ & Runtime”)
If all ...