Autopopulating formulas for column

Newcomer2

Hi,

Is there anyway we can have a parent row column and have the formula "=IF(COUNT(CHILDREN(FindingType@row)) > 0, 1)" auto-populate instead of having to type each formula for every row of that column? I would like the formula to actually show as 1 for the parent row instead of '=IF(COUNT(CHILDREN(FindingType@row)) > 0, 1).

Thank you,

Sophia

KPH

Hi @Newcomer2

Enter your formula into one cell in the column you want it to appear in. Here it is in Column2.

Press enter and check the formula is working.

Right click on the cell with the formula in.

Select Convert to Column formula.

The formula will now be applied to the entire column.

KPH

Hi @Newcomer2

Enter your formula into one cell in the column you want it to appear in. Here it is in Column2.

Press enter and check the formula is working.

Right click on the cell with the formula in.

Select Convert to Column formula.

The formula will now be applied to the entire column.

Newcomer2

Thank you so much for your help! :)

KPH

No problem at all. Glad I could help!