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
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
