Formula Assistance - Blank/Not Blank

[John_Dlouhy]

Hello Community!

Hoping, yet again, for assistance from a Formula pro.

My table has the following look up fields:

1 - {Invite Docs}
2 - {Other Task-Related Docs}
3 - {Calendaring Docs}
4 - {Plan/MTG/After Event Docs}

If there is a document in any one of these four fields, I need the Formula to return a value of “Has Docs”. In oher words, records that have blanks in all four fields would not return the “Has Docs” value.

I attempted an IF statement, but with unsatisfactory results! :worried: I’m afraid the use of BLANK () is currently beyond my skill level.

Thanks in advance for any assistance you can provide.

[ScottWorld · Accepted solution]

Using the field name alone will test if the field is non-empty.

So, your formula would be as simple as this:

IF(
OR({Invite Docs},{Other Task-Related Docs},{Calendaring Docs},{Plan/MTG/After Event Docs}),
"Has Docs"
)

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

[John_Dlouhy]

B R I L I A N T !!
Thanks so much!