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.