Formula Help

Stuart.d
Stuart.d ✭✭
edited 12/09/19 in Formulas and Functions

Hi,



Are you able to help?



I have a column named "snag" which is a red flag check box, then another column named "PM" with drop down name initials 



I need a formula that calculates, when a Red flag is raised and PM name is "XYZ" the result is = ZZ number of projects



I'm going wrong somewhere and can't get it right, see images and attempted formula



Regards 

SD



 

fORMULA HELP 1.JPG

FORMULA HELP 2.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!