How to compare four cells for text to return a value

[ENG Svc Ctr]@row

[PERMIT Service Center]@row

[LAND Svc Ctr Code]@row

[BID Location Code]@row

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!