I have 8 parent tasks with various numbers of children tasks. How do I keep a running total of the number of completed children tasks?
It kind of depends on how your data is formatted, but if you only have 1 column currently you won't be able to easily add parts of the text together using a formula.
My recommendation would be to have "totaldone" and "totaltocomplete" as columns. The children rows would be integer (number) fields that just count the number of tasks done and the parent row formula would be as below:
That way you would have a sum of "totaldone" and "totaltocomplete". Then, the formula for the "progress" column would be:
=totaldone@row+" of "&totaltocomplete@row+" Done"
That way both parent and child would display as "x of y Done"
Depending on whether completion is being recorded or calculated, you may be able to hide the extra columns.
Yes. You could use something along the lines of
=COUNTIFS(CHILDREN([Checkbox Column]@row), 1) + " of " + COUNTIFS(CHILDREN([Checkbox Column]@row), OR(@cell = 1, @cell <> 1)) + " Done"
First we count how many children rows are checked. Then we drop in " of ". Then we count the total number of children rows both checked and unchecked. Finally we drop in " Done".
How are you recording that they are done? Do you have a checkbox column, or a percentage column, or a dropdown column, or.......?
@Paul Newcome I am using a checkbox column. I believe that I may have found a way to calculate what I need by using additional columns to:
Is it possible to a create formula without needing to use additional columns?
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.