Can you skip a row and still use Column formulas?

Indira Buike

Hi! I've got this sheet where all columns use the same formula except for the first row which is a kind of "header" and is a text row, if a use column formulas that text is erased, I was wondering if there's a way to use column formula and skip that row. The formula I'm using is =SUM(CHILDREN()) but every time a create a new parent row the formula disappears.

Maybe the formula needs to include from which row to which row it applies to, I'm not sure.

Thank you for the help.

Andrée Starå

Hi @Indira Buike

I hope you're well and safe!

You can add another part to the formula, so it first checks if it's that row with the header, and if it is, it will show the header's name.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Indira Buike

Hi Andrée,

I'm sorry for the late reply, but no it doesn't really make sense, can you perhaps show me?

BSS

@Andrée Starå How to check if it's that row with the header if the formula has to be in that row for it to be a column formula?

Jackie M

I am also looking for a way to skip the first row using a column formula, in my case, using =[Column6]@row - INDEX([Column6]:[Column6], [Entry Number]@row - 1) - this formula will not work in row 1 I am assuming because there is no value to calculate with so I was thinking if there is a way to possibly wrap my formula in an IF statement to exclude row =1

Thank You,

Jackie