I need to convert an Excel Formula into a Smartsheet Formula

Sonja Liebenberg

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

SoS | Dan Palenchar

Hi @Sonja Liebenberg

Try

=(1-[Total Assurance provided]5) * [Risk Ranking Score]5

If your using this formula in row 5 I would use the below instead

=(1-[Total Assurance provided]@row) * [Risk Ranking Score]@row