Auto Generated Number formula based on value in another column

I need help with a formula:

Need auto-generated number based on:

If value in "type" column is "Type1", auto-generate number in column "number" , otherwise, leave blank

Cannot use Auto-Generate number column because of criteria

Can make column formula to ensure auto-generated number is in new and existing rows


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!