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.
So I am new to Smart Sheets but need to know how I create a Folder under the sheets section as shown by someone who was managing this before? Please if possible reply to kirk@ship-sts.com since I am taking over this Smartsheet but allowing the current owner to transition before I update credentials.
I came back from vacation to find that about 20 columns, with headers but no data, have mysteriously added themselves to my Smartsheet. I created this version by using an older sheet as a template 3 years ago and streamlined by deleting a lot of excessive information tracking columns. And I use some hidden columns, so…
When a user submits our form they can select the option to get a copy of their responses. The email they receive has some major formatting issues that need to be resolved - specifically our institution's logo is enormous in the email. Where can I edit the template for people who have elected to get a copy of their…
