Sign in to join the conversation:
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?
At this time the closest you can get is to create a new symbol column using the progress bar and apply a formula like this:
=IF([% Complete]2 < 0.25, "Empty", IF([% Complete]2 < 0.5, "Quarter", IF([% Complete]2 < 0.75, "Half", IF([% Complete]2 < 1, "Three Quarter", IF([% Complete]2 = 1, "Full")))))
Sadly, there is nothing that will show you accurately the percentages... there is not 33%, 44%, its only empty, quarter, half, three-quarters and full.
Is there a RACI template that Smartsheets already has or does anyone have any suggestions?
My user is in view only and we can't change it. My user was granted enterprise access and I've request admin access and been assigned it but my user still is view only. I was able to to do everything and I had to renew my license on my user, which is fixed. Sheets that I had created I can't even edit.
I have three columns I'm dealing with, SALARY IRA(check mark) IRA amount if the ira checkmark is checked, take SALARY *0.035 in the ira amount column