Autopopulating formulas for column

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

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

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.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!