Lori Carenzo
Lori Carenzo ✭✭
edited 12/09/19 in Formulas and Functions

This is my current formula and it is working fine.

=IF([New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6)

I want to add that if New/Existing is BLANK - to not return anything.  Not sure how I can modify this.  Help?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!