Column Formula to return 1st, 2nd, 3rd, etc. instance of a column entry.


I am looking for a Column Formula that will return the 1st, 2nd, 3rd instance of a column entry.

The following cell formula works, but I am not able to make this into a column formula and need it to be a column formula so that when our form users submit a new form the Delivery Count column automatically updates. This is my cell formula =IF([Task Name]@row > "", COUNTIF([Task Name]$1:[Task Name]1, [Task Name]@row), "")

Any help would be greatly appreciated!

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!