If more than value,Submit, if less No


=IF(Total score]@row > 2, [Executive Sponsor Approval]1 = "No"), "Yes", "Submit"), Executive Sponsor Approval))

Hello, I am new to formula writing. Can someone help me write a formula where If total score >=3, then change Executive Sponsor to Submit and if not, then change Executive Sponsor to No. I will have an approval workflow built on the Executive Sponsor Approval Column


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!