Formulas In Templates Reference to another Sheet

Options

Comments

Ella ✭✭✭✭

10/31/19
Options
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
Options
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
Options
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
Options
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
Options
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

Adjusting a Gantt view time for half day
Good afternoon, Is it possible through either setting a specific duration or formula to begin a task in the afternoon of a Monday and end at the end of day on Tuesday? I am creating a high-level view of an upcoming store project where some tasks beginning in the PM and finish the following AM and other tasks that start in…
Lock Columns to limit editing
It would be great if we could limit which columns in a sheet we will allow a user to edit.
Dynamic Team Task List
We have a team task list where we open up items, assign team members, create due dates, and update the status when closed. I am looking for a report / filter / view where I can filter closed items and group items by the assignee. Any suggestions?

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