-
Re: Child Auto Numbering per Parent Row
Hi Lamont, you can do this by getting a row number column, then ranking the collection of rows under each parent. I'm assuming here that the names (like CNC, Fab, etc) are in a column called "It…2 · -
Re: Convert text to contact
@Paul Newcome hooray!1 · -
Re: Collecting Duration a Row is on a Status
Glad you got it!1 · -
Re: Need help with COUNTIFS and Count(Collect) formulas
The CONTAINS was my suggestion when I thought you were needing to pull 2023 out of a longer text string. CONTAINS works with text, so you have to have "" around the 2023 if that's what you'…1 · -
Re: Collecting Duration a Row is on a Status
The suggestion to use a Row Copy is a good one. Otherwise you would have to write a formula for every possible combination…essentially impossible. So, setup an automation that copies the row to a sec…3 ·