Autopopulating formulas for column

Newcomer2 ✭✭✭
edited 02/13/24 in Formulas and Functions


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,


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!