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.
Hello! I see there was recently changes made to the login screen. When I began using this program for work, I was a regular user. I eventually was added to my company's enterprise account for the premium functionality. I used to select "Log in with company account" to utilize this access. Since the changes were made to the…
We need to share a couple of sheets to unlicensed colleagues for viewing and minor editing. Can you advise what’s the best way to handle this? Should we: Ask them to create their own free accounts - what is the downside of this? Is there an “expiration” on their account and will they no longer be able to view/edit sheets…
I use Smartsheet as a virtual data room, with each Workspace dedicated to a specific project. I will then invite different downstream colleagues to the project sheets. I would like to set-up a Confidentiality Acknowledgement statement that the colleague has to click on "Acknowledge", before being granted access to the…
