Help

Formula Assistance - Blank/Not Blank

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