I have a column "Priority Ranking" in which I want to prevent duplicate values. How can I achieve this?
Ranking priorities is always at the top of my list just never get to it... maybe I should have a sheet like this myself!
All joking aside one suggestion is the Row ID column format. In this way, the row id column can rank priorities for you, and duplicate values become an impossibility!
Let me know if this helps!
Skyway Consulting Co.
President and Chief Consultant
🌉Skyway Consulting Co.🌉
Need Smartsheet Help? Schedule a complementary consultation click SCHEDULE
Does your Dashboard need a map that updates from Smartsheet Data? We pioneered 101+ ways to add a map to a Smartsheet Dashboard.
Thank you for responding. The Priority Ranking column is a dropdown column. I have an auto number field "Backlog Item", but I want to prevent duplicates in the dropdown column "Priority Ranking". I'm not sure if your suggestion would work in my case. Any other possibilities?
Hi @Katherine Simpson
I hope you're well and safe!
To add to Ward's excellent advice/answer.
Is the data filled in the sheet or a form?
If it's a form, we could add Conditional Logic to make it work, but if it's in the sheet, we could add a message informing them that they can't use specific options.
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thank you for the additional information. Right now it is only a sheet. But I will be creating a form for data entry. So, let's go with conditional formatting. How would that work?
Happy to help!
How many options can you have? Also, depending on the specifics, It might not work with a form. Are the priorities set in one form submission, or would they be on different rows?
Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.