Performing standard algorithms on % Complete column

Hi, I can't beneath the % Complete column do any standard algorithmic computation e.g. =SUM(bla), =AVG(bla)

In any other column such options are auto-suggested when I start typing. In the % complete column it is not and the commands don't work. Kindly advise.

Thanks

Find more posts tagged with

Comments

Andrée Starå

Hi Walliz,

It probably doesn't work because you are using it as the % Complete column in the project settings.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Walliz

Hi, not really. If I create a new column and click % in the toolbar the same values are displayed in the column e.g. 0%, 50%, 100% etc. Under this column the formulas work. With the same values in the % Complete column the formulas do not work. Don't know why this is so, or if it intentional?

Andrée Starå

It's intentional. You can't have formulas in the Projects % Complete column. You could, however, have formulas in another column that reference the % Complete column.

Would that work?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Time Zones
Hi, I am getting conflicting information from Chat GPT and Copilot on whether I can change the time zone for my system time stamps. I have Pacific time showing up. We are in Eastern Standard Time. I have my setting in my profile set for Eastern Standard time, but it doesn't seem to change the created time stamp and the…
Smartsheet Performance Issue
By when the issue will be resolved?