Hello,
I want to have Smartsheet create project numbers following a specific format, but generate the number when I click a checkbox in another column. I cannot figure out how to make this work? Here's what I've done so far:
Column PN Auto is an auto-number column with prefix 'TD-' and numbers starting from 1700. I do not want to automatically assign a number to every row in my sheet. I would like to only generate a number once the checkbox in the 'Assign Project Number?' column is checked. When I create a workflow, it is not displaying the PN Auto column as an option (assuming workflows do not work with Auto-numbering formats). Is there another way I should do this? Maybe a formula?