Need help creating a count formula

ECD Auto Design
edited 11/08/22 in Formulas and Functions


I am attempting to create a formula that only counts the check box in "Final Workoff" IF the "Amber Items" is true otherwise if the "Amber Items" is false or blank and "Final Workoff" is checked the value should be zero. Any Suggestions?

Thanks, Anthony


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!