Best Of

We found out we need to use Brandfolder to allow for the metadata to link between the sheets.

Hello @Ami Veltrie

I believe it's still an issue.

I update sheets with data shuttle using expressions, such as the TODAY() function within them, and that seems to also update the TODAY() function without having to open the sheet.

Hi @Tamsin

Your formula is working correctly! In your screen capture, there are blank cells in helper VRN column for the child rows. This means the COUNT of the CHILDREN in that specific column is 0, since there is no data in those child rows.

Instead of referencing your helper column in the first COUNT, make sure you're referencing a column that will always contain text or data when a row is submitted. For example:

=IF(COUNT(CHILDREN([Primary Column]@row)) = 0, PARENT([helper VRN]@row), [helper VRN]@row)

Does that make sense?

Cheers,

Genevieve

Hi @K C Barnard

I hope you're well and safe!

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Also, it is possible to create multiple rows from one form, but it can get very advanced to structure a solution. I've developed a couple of various structures for clients.

I'd recommend seeing if my two-form solution could work.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

@Sam Minardi

There isn't a built in function for this so I would create it myself.

Set up a Check box column called Inactivate, then when its ticked the following could happen:

1) Conditional Formatting can be used to strikethrough the row

2) Automation workflow can be used to update the cell value in % complete to 1 (so that it doesn't effect % complete roll up)

3) Automation workflow #2 can be used to clear the cell value in Assigned To (so that the resource is no longer assigned to the row)

4) a Filter can be created and shared on the sheet to remove any tasks that have been checked in the Inactivated column

Would that work?

Kind regards

Debbie

Hi @Sam C

Something like this perhaps?

=IF([Remaining]@row > 0, "Green", IF(AND([Remaining]@row >= 0, [Remaining]@row <= 0.5), "Yellow", "Red"))