BobbyHollis
5 years agoQrew Member
Help! This formula has to be simple, but it's not ... for me
Hey there, trying to make a formula field in a report that simply flags product names that changed at certain points of the funnel. The fields referenced in my attempt are fields that capture the product name at certain stages, got that figured out, but now I want a report that shows only those that changed.
First stage field (text) I have memorialized is called Product @ PQ
Second stage field (text) I have memorialized is called Product @ CFC
Basically, want it to say 'If the Product @ PQ DOES NOT EQUAL Product @ CFC, "YES", "NO"
My attempt:
IF (Contains([Product @ PQ],"SBA"), Contains([Product @ CFC], "Conventional"),"YES","NO"
screenshot of my error:
------------------------------
Bobby Hollis
------------------------------
First stage field (text) I have memorialized is called Product @ PQ
Second stage field (text) I have memorialized is called Product @ CFC
Basically, want it to say 'If the Product @ PQ DOES NOT EQUAL Product @ CFC, "YES", "NO"
My attempt:
IF (Contains([Product @ PQ],"SBA"), Contains([Product @ CFC], "Conventional"),"YES","NO"
screenshot of my error:
------------------------------
Bobby Hollis
------------------------------
- Try this
If([Product @ PQ] <> [Product @ CFC], "YES", "NO")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------