Archived 2017 Posts
Archived 2017 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Calculate % Comp but retain dependencies
Hello. This seems simple, but it's stumping me. I have a project Gantt chart, and some of the child tasks are simple numerical completions of tasks. In other words, if I have 300 of a certain thing that need to be done, and if I have a user input that he or she has completed 100 of these, I can calculate a completion percentage of 33%. However, I'd also like this calculated value to be linked to the master % Comp column for this task, but SmartSheet won't allow this without me removing the dependency to Predecessor in the project settings for the % Comp column, and this defeats the purpose of what I am doing.
Any suggestions? Thanks.
Dennis
Comments
-
Dennis,
Smartsheet does not currently allow formulas in any of the columns tied to the Project Settings.
Either the user determines the % Complete or provide them with the calculated value and let them enter the data in both cells (# Completed and % Completed)
Craig
-
Craig, OK, that's what I was afraid of, and that's what I'm having them do presently. Not a very elegant solution, or as we engineers call it, a kludge.
-
Dennis,
Depending on number of sheets and /or number of times the data is updated, the [% Complete] of non-parent rows can be updated via the API or third party tools like Zapier (www.zapier.com)
Craig
-
Craig, I fear that's way over my head, but thanks anyway. I can barely spell API.
-
Dennis,
Then try Zapier. Extremely user friendly, no coding required.
Craig
