Comments
-
@Paul Newcome - Thank you for your help. and thanks for the condensed formulas that came in as a bonus for me!
-
@DonaraJaghinyan - Try adding a Flag column and use a formula like this to trigger the flag when all predecessors are complete and the Successor is ready to start: =IF(AND(Predecessors@row <> "", [% Complete]@row = 0, SUMIFS([% Complete]:[% Complete], Successors:Successors, HAS(@cell, Row@row + "")) =…
-
Heather Duff - Thanks. Not ideal... perhaps a product enhancement candidate?
-
Paul Newcome - Thanks Paul. It appears to have been some sort of a glitch in Smartsheet. I was trying to figure out the issue and added a blank column between the 2 date columns and the error messages went away! Deleted the blank column and the errors didn't re-appear.... So I guess it was a freak phenomenon Thanks for…
-
Paul Newcome - Thanks. I have checked the cells in all sheets and they are set as Dates. I also validated this by changing the date Format for the cells from the standard "mm/dd/yyyy" to "mmm dd, yyyy" and the dates pick up the new format. I did notice that even though these are set up as date columns, but the dates are…
-
Heather Duff - Thanks for the suggestion. I have set up most of our reports filtered for "Current User". Would this require for me to create separate report for each user or role?
-
Hello Myra, You may like to see the solution suggested by Paul Newcome using the new SUCCESSOR function. https://community.smartsheet.com/discussion/84257/successors-testing#latest It allows you to flag a row when all predecessor tasks have been completed. I found that solution very useful for more than 90% of tasks on my…
-
Hi Julio S. - Thank you. That is very helpful and works!
-
@Paul Newcome and @Vivien Chong - You just made my day! Thank you for your insightful help!
-
戴尔-在一个理想世界中,是的。我点的managing 50+ concurrent, fast-paced projects each, continual adjustment of Planned Finish Dates is not practicable.
