Sign in to join the conversation:
Hi,
I need to be able to calculate the % complete of a project in the parent row based on % complete of a number of tasks in the child rows and the project duration without using Predecessors column.
Can anyone help??
Thanks,
Bill
Hi Bill,
Try this out:
ROUND(AVGW(CHILDREN([% COMPLETE1]), CHILDREN(DURATION1)), 2)
Best,
Kara
First of all, I use Smartsheet Gov. I have the following workflow set-up. I wish to add another component to it, but I am not sure how to do it. In addition to the date being recorded as shown, I also want an email sent to a specific address. Oh, and I also need to have the Trigger set so it ONLY works when today's date is…
Hello - This morning when trying to go to Smart sheet University, my peer and I clicked on "help" and nothing happens. It was working fine Friday, but no longer working today. Can't get to help or Smartsheet University. Anyone else having this issue? Used in Chrome and Edge browsers
I'm running into a strange issue with automations and email delivery, and I'm hoping someone can clarify how to fix this. Setup: I have a Smartsheet form with: A required “Your Email” field (Contact column) Several hidden Contact List fields populated automatically Automations use “Send to contacts in a cell” Submitted…
