nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Parent level approval requests?

Angie Hatfield

Is there a way to set up approval requests at the parent level?

Parent row includes project description, Owner, PMO, etc, etc.

Child rows break out task types into groups

Grandchildren row list owners of each task under the task type group.

Example:

Description Owner PMO

Project XXX Jon Doe Pam PMO (Parent row)
Requirements (child group 1)
Requirements Pam PMO (grandchild row)
Test scripts Jason Jones (grandchild row)
Development (child group 2)
Development Chris Smith (grandchild row)
Unit Test JJ Johnson (grandchild row)

We use same Owner column for parents & grandchildren. I would like to set up a notification & an approval request at the parent level for the project Owner when all of the tasks are completed. I really don't want to add another column. I have a bunch of hidden columns already and would like to minimize if possible.

Thanks ahead of time,

Angie

Find more posts tagged with

Comments

Andrée Starå

Hi Angie,

What other columns are you using at the moment? It might be possible to use them to accomplish what you need.

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Angie Hatfield

Hi Andrée,

This may be overkill, but thought it may be helpful. Here is a list of all of my columns. Hidden have purple text. It explains each column and what level it is. I also have a screenshot that shows 3 views. Parent row rolled up, Parent & dhild rows, Parent, child, and grandchild rows.

If there's anyway to figure out how to use Owner at Parent level to get approvals, it would be great.

Thanks!

Angie Hatfield

Andrée Starå

Happy to help!

What formula do you have in the Ancestors formula?

Angie Hatfield

=COUNT(ANCESTORS(Project1132))

Let me know if you want the rest of them.

Thanks again!

Andrée Starå

Maybe you could use a combination of the COUNT of the ANCESTORS and the percent complete.

Would that work?

Angie Hatfield

Hi Andrée,

I think that will work! I should have thought of that. I really appreciate you taking a look at this and finding a solution.

Have a great week!

Andrée Starå

Excellent!

I'm always happy to help!

Have a fantastic week!

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…