Autopopulating formulas for column

Options
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

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Newcomer2

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

    image.png

    Press enter and check the formula is working.

    image.png

    Right click on the cell with the formula in.

    Select Convert to Column formula.

    image.png

    The formula will now be applied to the entire column.

    image.png


    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!