How to create a CHART that show completed and remaining task?

Options

Maxkon

Maxkon ✭✭

04/18/22 edited 04/18/22 in Smartsheet Basics

Hi,

0 ·

Answers

Nabil Hayek ✭✭

04/19/22

Hi,

You can add an extra column for Complete and Remaining. Use the "count if" formula to count how many completed and how many remaining, and then you can use the chart widget in dashboard

Hope that helps

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Why is conditional formatting not working on my sheet?
I have set up this conditional formatting rule to highlight a row when the Customer Name is #No Match. So far it is not working. I have tried changing it to contains instead of is and still doesn't work. What am I doing wrong? Janet
Can i create form to edit existing data
Hi, I am trying to work out if smartsheet is able to create a form to edit existing data , i have a project looking after around 900 stores with constantly moving and updated items within the stores i wanted to know if a i had a specific data source "Store ID number" for example, that when you enter the store ID it pulls…
Question regarding automations (triggers)
I have a question regarding triggers. Is it possible to create a trigger when you say cell C you have the year as 2025 and when that cell C says 2025 it triggers cell d to write the word active. When the 2025 is changed to 2026. there is a trigger to remove active so cell D is now blank. Thank you

woman with hands out and open

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video<