sumif parent row

I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row

=SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter}, =PARENT({Matter}@row)

I keep getting an error in the formula

parent sum if_LI.jpg

Find more posts tagged with

Formulas

Legal

Project Management

Comments

Paul Newcome

Unfortunately you cannot use hierarchy functions in cross sheet references. It would be nice though, so feel free to fill out a Product Enhancement Request.

In the meantime though, you could add a helper column on the main sheet. In that column, you could use a simple

=PARENT(Matter@row)

This will pull whatever data is in the parent row into the current row. You can then use the Helper column in your SUMIFS.

Sign in to join the conversation!

Quick Links

Trending discussions

Netdays Formula
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…
Attaching a Message Sent to Vendor Acknowledging Contract
I've set up a Smartsheet that sends an approval request to a vendor to accept the terms of employment (outlined in a PDF generated with information from the sheet). They are not required to sign the document, just click Accept or Reject. While the contract (PDF) is attached to the row, and while I would have a date in the…
Re-write a formula to make it Column Formula compatible
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…