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.
Counting Number of Times a Predecessor is Used
Long story behind this one, I'll try to keep it short.
On Smartsheet, the critical path tool isn't working for my sheet because our project has too many hard deadlines and we are not using enough predecessors; however, we need to be able to view a critical path, so I have accepted that I will have to create one manually. I am trying to use certain features to make this easier for me so that I do not have to do Conditional Formatting by Task Name all the time to mark the critical tasks as red in my Gantt Chart.
What I am trying to do is count how many times a particular task has been used as a predecessor in the Predecessors column. Then I will create another column that designates "Yes" or "No" as critical path item, depending on the number of times that task was used as a predecessor. If "yes" in that column, the task will automatically be highlighted red on Gantt Chart.
However, having a hard time with formulas. I've tried COUNT, COUNTIF, IF, to try and generate the # of times a row number is used as predecessor, for example: =COUNTIF(Predecessors:Predecessors, 6). (for row 6). I created a new column called "Number of Dependencies" where I have put this formula. I would then want to create a formula in "Critical Path?" column that counts if Number of Dependencies>7, then "YES" in "critical path?" column. Then use conditional formatting to highlight those tasks red.
But I can't get the formula to count how many times a row is used as a predecessor. Am I messing up the format?