Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Forgive my naivety as I'm still green at formatting. I'm trying to use the Auto-Number function in a column. I don't want all cells in the column to populate - only if column c isn't blank. I can't seem to get this to work where the auto-number will popular a cell if column c contains anything?
Hi Denise,
Unfortunately, it's not possible at the moment to limit the have dynamic auto numbering from the feature in Smartsheet. It's all or nothing. Great idea, though!
Please submit an Enhancement Request when you have a moment.
A possible workaround could be to use formulas but depending on your structure that might not work.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Are you able to provide more detail as to how exactly you want things populated and the layout of your sheet? Are you able to provide screenshots with sensitive/confidential data blocked, removed, or replaced with "dummy data"?
Sure. What I'd like to happen is have column A designated as custom auto-numbered. However, I have header rows and don't want auto-numbers to populate unless there is action on Column C. So, every time Column C ISN'T blank, I'd like Column A to generate an auto-number. Using this as a non-compliance tracker so essentially want a unique number to be associated with each row entry.
Ok. Next question...
Would you want it to be populated by row and only visible if needed? For example:
.
1
2
3
4
5
But only 2, 3, and 5 are needed so you would see
Or would you rather see
The latter option. I only want an auto-number generated on Column A when there is activity on column C.
I forgot that leaving gaps between rows in the forum doesn't work.
Here is what I meant to show... If you have
and you only need 2, 3, and 5, would you want
blank
or would you prefer
I am going to assume you knew what I intended and still want to go with the second option.
In that case, you would want to add in a text number column to house the numbering system and use the following:
=COUNTIFS([Column C]$1:[Column C]@row, NOT(ISBLANK(@cell)))
You're right. I'm looking for the last option. Not clear from your email how to use that formula. Tried it and didn't seem to work. Would you mind if I invited you to my sheet so you can take a look?
Seems like it's probably a simple fix. I'd be happy to take a look and fix it.
Can you maybe share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
My apologies. The formula would go in [Column A]1 and you would then dragfill down the sheet.
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
