Hi, i'm a newbie and have a question about Smartsheet. I was wondering if Smartsheet can do the following: I would like for the parent task to be marked 100% complete and Status=Complete when the sub-tasks are 100% complete and Status=Complete. For example, I have a task call "Deploy Server" and there are 3 sub tasks underneath it ("Task 1,"Task 2",Task 3"). When the last sub-task has been marked 100% and Status=Complete, the Main task called "Deploy Server" is marked 100% and Status=Complete. Is there a way to do that? Thanks in advance.

Ok. Try something like this in the Status Column... =IF([% Complete]@row = 1, "Complete") If you wanted to go ahead and show "Not Started" for 0% and "In Progress for 1% - 99%, you could use something like this... =IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))

automation - mark Main Task 100% complete and Status=Complete when all sub tasks are complete

Answers

Paul Newcome ✭✭✭✭✭✭

02/28/22

@Cyndi You are going to want something like this...

=IF(COUNTIFS(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIFS(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", "In Process"))

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Trending in Smartsheet Basics

Insert Image into Report
I have a report that I would like our subcontractors to upload photos into. It has gotten a little burdensome to figure out which rows have the information we need with all of the attachments per row, and we thought it would be a good idea to put a single photo into a cell instead of an attachment; however, I can't seem to…
Sharing workspace to user without license
Is it possible to share the workspace with a user who doesn't have a license? I have already shared the link and added them as an editor, but they are still unable to view it. Thank you!
Possible to use a Smartsheet form as a formmail/sendmail?
My group has a need for a formmail/sendmail-type option, and I'm not sure if Smartsheet forms can be customized to do this. Need to be able to use a form to: Send emails with a return address from our team mailbox (not from automation@app.smartsheet.com) Specify a recipient for each form submitted Send to multiple…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

automation - mark Main Task 100% complete and Status=Complete when all sub tasks are complete

Answers

Categories