Functions for predecessors
Are there Smartsheet functions for enumerating the predecessors of a row?
I've been prototyping SmartSheets for managing a pretty sizeable research project (multiple FTEs over several years), potentially replacing Asana for group project management. The reporting is nice, as is the combination of spreadsheet, gantt, card, and resource views. The main thing I'm missing is the ability to show, particularly in the card view, all of tasks whose predecessors have been completed and are available for work. It's something I and my staff does on a regular basis in Asana, and for the large planned-out research projects my Center runs, it's basically essential for how we work and I cannot find a way to do it easily in SmartSheets.
If there was a function for enumerating predecessors, I could simply COUNTIF the number of non-Completed predecessors, and make a row available for work once the predecessors are all Completed. Then I could set up a filter in the Card View to show cards assigned to me that are available for work. This seems like pretty essential functionality to make predecessors useful, but I cannot find a way to do it. Is this possible or planned in the near future?
Help Article Resources
Check out the Formula Handbook template!