Formulas In Templates Reference to another Sheet

Comments

Ella ✭✭✭✭

10/31/19

Hi Andree, it did not work. Thanks for your help with this!

0 · Share on Facebook Share on Twitter
Andrée Starå ✭✭✭✭✭✭

10/31/19

Happy to help!

Ok. I'll try again and get back to you!

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter
Andrée Starå ✭✭✭✭✭✭

11/04/19
Try this.

Change the auto number column to Text/Number

Delete the values in the column

Save

Change to Auto-Number and add Starting number 1 or the next in the series

Save

Done!

Did it work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter
Ella ✭✭✭✭

11/04/19

Yes, it finally worked! Thank you so much, Andree, you rock!

# 4 - adding a Starting number of 1 was the little detail I was missing! Thanks again!

0 · Share on Facebook Share on Twitter
Andrée Starå ✭✭✭✭✭✭

11/04/19

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

standardized x-axis range on a line graph
When using a side-by-side comparison of data with the same benchmarks, but different data points, is there a way to standardize the x-axis range so that the benchmark line in the two graphs are aligned?
Contact support chat feature
We have an enterprise account and only just noticed this a week ago. Does anyone know when this feature was implemented and is it a live chat session or chatbot driven? Thanks
How do I create a crew filtered by Individual, with proof function?
Hi - we are adopting Smartsheet as our Creative Services request/management tool. I need to create a view where individuals can see and update the requests that they have submitted. I was planning to use Dynamic View, but it does not have the ability to see or interact with Proofs. Any other suggestions?

Help shape the future of Smartsheet.
Share your ideas and feature requests.