How do I build a formula to count up a specific value based on another column


Trying to build a reference ID that is based on another column's content while counting up the reference ID based on the amount of that specific value from another column.

Multiple incidents can occur against the same customer PO and we need a reference number that starts at 01 and counts up if customer PO comes up again during other captured incidents.

Your help is much appreciated!!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!