Comparing fields and posting a result

Question

I'm trying to display a value in field 3 using a formula see example belowso if field 1 and 2 have a value don't callif field 1 or 2 are empty or both fields are empty call.EgField 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Field 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Field 3&nbsp;23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/05/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;don't call515&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blank&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;call54848&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;01/05/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;don't callBlank&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blank&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;callBlank&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/05/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; call

kevinslider · Answer

Hello,&nbsp;I would write a formula similar to this:If([Field1]="blank" OR [Field2]="blank", "Call","Don't Call")if the field is truly blank, as in, a null value, replace "blank" with "" in the formula.If([Field1]="" OR [Field2]="", "Call","Don't Call")Let me know if this helps.

anthonybutcher · Answer

thanks will try that

Forum Discussion

Comparing fields and posting a result

2 Replies

Related Content

Jinja Expression Comparing Now to Now+Hours

Spam posts

Hi, my first post here

An API(?) button to copy fields from the form, to other fields

Change Webook date format in JSON POST

Recent Discussions

Can I use quickbase actions within the same table?

Question about relationships

Reports & Charts - Managing Client-Specific Name Visibility

Summary Table Question

Google Search is back