Forum Discussion
MarkShnier__You
Qrew Legend
5 years agotry this
IF(ToText([Origin Name]),"lineage","#fce069",
Case(ToText([Shipment Status]),
"Delivered","#dadada",
"Booked","#f0f0f0",
"Rated","#f0f0f0",
"Scheduled","#f0f0f0",
"In Transit","#f0f0f0",
"Delivered ; In Transit","#f0f0f0"))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(ToText([Origin Name]),"lineage","#fce069",
Case(ToText([Shipment Status]),
"Delivered","#dadada",
"Booked","#f0f0f0",
"Rated","#f0f0f0",
"Scheduled","#f0f0f0",
"In Transit","#f0f0f0",
"Delivered ; In Transit","#f0f0f0"))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
AlycnBjergo-Jus
5 years agoQrew Member
Oh, I need it to contain the word Lineage in formula 1 - how can I write that?
------------------------------
Alycn Bjergo-Justen
------------------------------
------------------------------
Alycn Bjergo-Justen
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
IF(Contains(ToText([Origin Name]),"lineage"),"#fce069",
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- AlycnBjergo-Jus5 years agoQrew MemberThank you - that worked!
------------------------------
Alycn Bjergo-Justen
------------------------------