@column alternative / is there an @column function?


Hi everyone,

I've created a formula that I'd like to replicate over many columns. I know I can paste it and change the column number, but is there a way to instruct the formula use a numbered row (in this case, 20) and the current column? Something like @column

=COUNTIFS({April/May 2021 Boot Raw Data Range 1}, [Primary Column]@row, {April/May 2021 Boot Raw Data Range 2}, "Yes", {April/May 2021 Boot Raw Data Range 3}, =[Column3]20)

Thanks for your time,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!