Survey results (and what's coming next)
Thank you all for giving us your feedback in the recent Smartsheet Community survey! Based on your thoughts, we're excited to announce that we have many changes coming in just a few weeks. Read our survey recap post for more details.
Answers
@Fabrizio Pirulli Happy to help. 👍️
thinkspi.com
@Fabrizio Pirulli
Happy to help!
I saw that Paul answered already!
Let me know if I can help with anything else!
Best,
Andrée
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Hi all, I am trying to do the same thing and read this post. I want to show which phase of the plan is currently active by showing the parent task description. In plan example below the yellow lines shows the descriptions I need. You will see the third phase of this plan (Defined,Scoped and Analyse) is the current phase as the ones above are 100% complete. I used the formula you mentioned in this thread =INDEX(CHILDREN([Task Description]@row);COUNTIFS(CHILDREN([% Complete]@row);@cell=1)+1) but amd getting unparseable. Any ideas please? Screen shot of the relevant columns of my plan are shown below:-