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
Check out the Formula Handbook template!