Welcome!

Easy Question : % Complete

Hello,

How do I get my % data to roll up to 100?

Its looking like all of the data is running up to 1.

Does that make sense?

Sorry for the hopefully easy questions.

Thanks

- Alex

ss capture.PNG

Sheets

Format the column to %

(4th from the right on the Format Bar)

Hello,

I did this. Nothing changed.

You still see 0.36 instead of 36%?

The [% Complete] column treats 0-1 as 0-100%

Craig

That is correct.

Smart % 2.PNG

Smart %.PNG

Hello,

I figured it out. I needed to select the % format.

D'OH!

Thanks,

Alex

Capturing Cost Savings by the month
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Automation to send Reminder @ 60d, 30d, etc
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
How do I share a report document to an external client without having to give full access to the doc
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…