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

Referencing to Smartsheet table (consisting of 30+ columns) in INDEX/MATCH formula but shows error
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…