Need a formula to trigger a red flag

I've set the column to symbol/flag and I want the top row to flag if any of the below rows have a flag in it. I've tried numerous items but all return an error of either invalid or that the cell is restricted to flag value.

Best Answer

  • Kelly P.
    Kelly P. ✭✭✭✭✭✭
    Answer ✓

    @Missy Folkemer

    If you indent all of the rows under the first row, then you can place the formula below in the first row of your Flag column. It will flag itself if any of the children are flagged.

    =IF(COUNTIF(CHILDREN(), 1) > 0, 1, 0)

    Hope this helps!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!