Sign in to join the conversation:
Hello,
looking for a formula that would mark the parent cell Complete after all the children cells are marked Pass.
Try something like this...
=IF(COUNTIFS(CHILDREN(), "Pass") = COUNTIFS(CHILDREN(), OR(NOT(ISBLANK(cell)), ISBLANK(@cell))), "Complete")
Thanks for the reply but it shows unparseable.
Can you post your exact formula that you are using? Screenshots would also be very helpful. Sensitive/confidential data can be removed, hidden, or replaced with "dummy data" if needed.
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
I have no idea how to start the program. I need the basics on how to build charts and graphs.
Hi, I’m having trouble transferring ownership of a sheet and would really appreciate some advice. Current situation: I am on a Free plan. The sheet is owned by me and stored in a Workspace. Another user is an Editor on the sheet. The sheet permissions are managed via Workspace sharing (not individually per sheet). What I…
