Skip to main content
Question

Need help with the formula field

  • September 29, 2022
  • 0 replies
  • 10 views

Hi Everyone,

I've 2 fields need to be used in formula field - Meeting attended (field type checkbox) and  vote (field type text).
If not attended the meeting and still registered vote
then new formula field should show text "not attended but still saved vote"
else can keep this formula field blank.


I'm writing like this but getting error, please advise what is missing. 
If([Meeting Attended?]=false and not IsNull([Vote]),"Not attended meeting but voted", " ")

------------------------------
Mrunali Kadam
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You cannot test for blank in a text field with IsNull.

try this

If([Meeting Attended?]=false and [Vote]<>"",  "Not attended meeting but voted", " ")

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------