Assign Contacts to Child Rows Based on Criteria in Parent Row
We have multiple stages in our projects that are set up with a parent row and then child rows below. I would like to assign a contact to the parent row of a stage and have that contact automatically assign to all child rows below. Is there a way this can be done without add-on software?
Answers
-
Kleerfyre ✭✭✭✭✭✭
So I would advise against putting a contact in a parent and in a child row as they will have that time they are working on those tasks counted double. So if you ever end up using resource planning, your numbers will be greatly off due to the doubling of all their time. If you still want to do this, all you would have to do is put an = in the the first child cell then click on the parent cell. It will populate the formula for you. Just put a $ in front of the number that comes up when you click on the parent cell. Now, just select the first child cell and mouse over the lower right corner until the + cursor comes up. Click and drag down for all the children under that parent. Repeat for each grouping.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
JMadd ✭
为某事感谢the advise however, I have previously tried this and I am not able to create a formula in the contact column cells. The new cell just reads "=" and will not take the formula. I have the same idea for some of the other columns that copy down without issue. The column with issue is set up as a contact list.
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/106465/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/106465/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>