Auto fill cells with a number

phollingsworth79111

I am trying to create an auto fill with a number. If Cell 2 is 5 then Cell 5 is 7%. Is that something I can do in Smart sheets?

I am working on a commission smart sheet and the commission % depends on how many years the contract is for.

 

Thanks

Andrée Starå

Hi Patricia,

Try this.

In my example, I've used the same column because you wrote Cell 2 and Cell 5 but it can, of course, be updated to look at different columns instead and that is probably what you need.

=IF(Commision2 = "5"; 0,07; 0)    

The same version but with the below changes for your and others convenience.  

=IF(Commision2 = "5", 0.07, 0)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting