Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 20, 2023 12:36 AM
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:
Jul 20, 2023 02:20 AM
From what I see, there should be no problem with this formula....Why?
Maybe try changing "Locking" in both tables to some other string?
Jul 20, 2023 05:50 AM
In "Proposal Type", try checking if the record the text "Locking" has a space in front or trailing, i.e. " Locking" or "Locking "?