Sign in to join the conversation:
Hi all,
I try to add colomn for % of theoric progress and use it with the real progress on formul to define different status (Done, Not Started,Task in Overdue, Work in Progress)
Hi Adil-Dkaki,
Smartsheet treats percentages as values between 0 and 1. For example, 0% should be expressed as 0 in a formula, 75% as 0.75, and 100% as 1.
Try converting your percentages into decimal values in the formula (make sure to remove the % sign as well). Here's an example of the formatting using a small chunk of your formula:
=IF(TODAY()<[Columne]5, 0)
How can I delete old sheets I no longer use from my account?
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…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
