Help

How to create an If Statement based off a Link Field with Words

Topic Labels: Formulas
771 2
cancel
Showing results for 
Search instead for 
Did you mean: 
PStringer5AH
4 - Data Explorer
4 - Data Explorer

Hello Community,

I have tried to find this answer but come up with nothing so far.

I wish to create an If Statement based off a Link Field which contains words.

Below is my issue:

'Proposal Type' is the Linked Field which can have multiple different word options.

My objective is if 'Locking' is selected in the 'Proposal Type' field, return the value 0, otherwise return the Minimum Freight Total. (i.e. locking doesn't include freight).

The formula I believe should work is:

IF({Proposal Type}='Locking',0,{Helper Minimum Freight Total})
 
However regardless of the Proposal Type, the value is always returning "Helper Minimum Freight Total"
 
PStringer5AH_2-1689838569954.png

 

 
Any help would be greatly appreciated.
 
Thanks 
Paul
 
2 Replies 2
Sho
11 - Venus
11 - Venus

From what I see, there should be no problem with this formula....Why?
Maybe try changing "Locking" in both tables to some other string?

In "Proposal Type", try checking if the record the text "Locking" has a space in front or trailing, i.e. " Locking" or "Locking "?