Conditionnal auto numbering

Hi there, i'm looking the possibility to generate or not a number depending of the value on another column.

For ex, column A : Yes/NO

Colum B autonumbering

If A = Yes, i will have a auto number, if no, the field stays blanck.

Many thanks in advance !


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!