Sign in to join the conversation:
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
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
When I use the zoom-in option, I can only see the day names but not the specific day numbers. I need my team to be able to see the exact dates for the tasks I have scheduled.
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
