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 ...
