column formular?


Hi Experts,

I'm using this formula to calculate how many rounds I have done.

=COUNTIFS(Season$1:Season@row, Season@row, [Dev Type (Article)]$1:[Dev Type (Article)]@row, [Dev Type (Article)]@row, Factory$1:Factory@row, Factory@row, [Article#]$1:[Article#]@row, [Article#]@row)

It works, if I copy it in each new row, but I would like, that whenever a new row is added, that this formula is cascaded as well.

Any idea how, I could modify it and change it to a column formula?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!