If a task has a number of sun-tasks, and their status is updated (Not started, In Progress, Complete), how can the overall task (parent) status be automatically updated.
A Nested IF formula should work.
=IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Complete"), "Complete", IF(OR(CONTAINS("In Progress", CHILDREN()), AND(COUNTIF(CHILDREN(), "Complete") > 0, COUNTIF(CHILDREN(), "Not Started") > 0)), "In Progress", "Not Started"))
IF the number of child rows = the number of child rows marked as Complete -> Complete
IF not -> IF either any child row contains In Progress OR at least 1 child is Complete AND at least 1 child is Not Started -> In Progress
IF not -> Not Started
If I have a status column that has manual drop down, with Not Started, In Progress, Complete - would this formula sit in the parent task cell, but in a separate column?
The formula as I wrote it would sit in the parent task cell in the same column. You can put formulas in columns that are drop downs. However, if anyone used the dropdown to change the value in the parent column, it would delete the formula.
Is there anyway to lock the parent cell so that changes cannot be made?
When counting the total number of tasks, does Smartsheet ignore the parent, i.e. only counting the children?
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.