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

Dennis Wierzbicki
Dennis Wierzbicki ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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.




This discussion has been closed.