Hello,
I am trying to add the children count of several columns but I just have a 0 as a result of a simple =Sum() formula.
Hi,
Not sure I follow! Do you want to sum the 6+6+6 on the same row or all the children for those columns or something else?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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…
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…
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…
