I need to convert an Excel Formula into a Smartsheet Formula

Options

Hi,

I need to convert this excel formula into a smartsheet Formula please? Whatever I try comes up unparsable
=(100%-Y5)*E5
Y5 in smartsheet is Column named "Total Assurance provided" and E5 in Smartsheet is Column "Risk Ranking Score"
I have tried several formulas, and just can't seem to get it right?

Any help would be greatly appreciated
Thanks
Sonja

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!