generating a defined number of IDs
Dear Smartsheet community,
I am trying to write a formula to generate a defined number of IDs.
In the screenshot below, if I enter 6 into the blue squared cell, I would like that 6 IDs are generated with a number incrementing at the end (ID_1, ..., ID_6).
if I enter 3, 3 labels are generated. (ID_1, ID_2, ID_3).
How could I proceed to generate these IDs based on a desired number ?
Thanks for your support!
Help Article Resources
Check out the Formula Handbook template!