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.

Formula Assistance - Blank/Not Blank

Topic Labels: Formulas
Solved
Jump to Solution
1982 2
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Dlouhy
7 - App Architect
7 - App Architect

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.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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
7 - App Architect
7 - App Architect

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