Hi, I’ve created two columns to reflect Task Completion % for each Phase of my project. One column is a formula column and the other is a Progress bar column. Each has the same formula. The Formula column is calculating correct but the Progress bar column isn’t reflecting the value. Is there something I need to adjust?
1 Like
I think we need more information to be able to diagnose the problem, such as what is the formula and what other columns the formula is referencing. The screenshot is not displaying the full formula, so I will suggest things based on my guesses.
I see you are using the Filter formula.
- Have you checked if what the filter returns is a single number, and not an array/list of numbers? If Filter returns more than 1 result, the Progress column will not work.
- Have you checked if the output of your formula is a number and not a string/text? For example, if the output of the formula is
“ABC”it will not work, but if it is“50”or50without the quotation marks it should work. - Have you checked the error that the row is showing? It might give you a hint on what has gone wrong. You can check the error by hovering your cursor over cells with the red triangle on the corner.
1 Like
Hi Larissa,
Here’s a screenshot of the columns side by side with the same formula. The Formula column (right) is showing the correct value - the output is a percentage. I’m confident the formula is correct because it’s calculating correctly in this column. I pasted the same formula into the Progress column (original post screenshot) but the value isn’t reflecting in the progress bar. There’s no error, the Progress bar just doesn’t show the correct value. It also allows me to manually adjust the progress bar value (which I don’t want). This makes me think it’s a setting on the Progress column and not an issue with the formula itself. Is there some sort of conversion that needs to be done because it’s a percentage?
This is the formula: [II/IM Project Tasks].Filter(Phases.Contains(thisRow)).Status.CountIf(CurrentValue.Contains(Done))/[II/IM Project Tasks].Filter(Phases.Contains(thisRow)).Status.Countall()
1 Like
Hello, @Alison_Shen-Ichikawa! Check this doc that I made on how to set up a progress bar in coda.
Understanding this will make you able to use it in your doc.
1 Like
Thank you! I had it referencing the value in the other column but maybe I didn’t set it up correctly. Is there a way to move the formula to the one Progress bar column? Vs. referencing another column’s value.
1 Like
Thank you for sharing the formula!
I will share some insights on your initial setup, and suggest changes to get closer to what you probably intended.
It also allows me to manually adjust the progress bar value (which I don’t want).
From the information provided, I think you set the values in the “Default value” field of the Progress column. This will set a value to the cell a single time, but it will not update later when the progress has changed based on other references. This is also why you can manually adjust the progress bar.
The correct place to add formulas so that it updates the cell in real time is in the “Add formula” option.
After you add the formula there, you can change it later if needed in the Edit Formula menu:
Or after entering Edit column, you will see it in the tab beside column settings.
There’s no error, the Progress bar just doesn’t show the correct value.
By “correct value” you mean the number with decimals? So 8.33 is correct but 8 is not?
If that is the case, the rounding is happening because you set Increment to 1, and to reflect two decimal places it would need to be 0.01 instead. But once you place the formula in the correct place the Increment field will disappear anyways, because that field is there only in the case you want to manually adjust the progress bar.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.