Skip to main content
Solved

Formula Assistance - Blank/Not Blank

J
Forum|alt.badge.img+9

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.

Best answer by ScottWorld

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:

View original
Did this topic help you find an answer to your question?

2 replies

ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8786 replies
  • Answer
  • June 23, 2020

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:

J
Forum|alt.badge.img+9
  • John_Dlouhy
  • Author
  • Known Participant
  • 43 replies
  • June 24, 2020

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

ScottWorld
1 person likes this
  • ScottWorld
    ScottWorld

Reply


Most helpful members this week

Terms & Conditions