force the choice in a % column to a couple of value
Hi,
a have a column "%" i would like to force the possible value to "0%" or "100%" during the inser
Is it possible?
Umberto
Answers
-
I hope you're well and safe!
Yes, you can use a Workflow combined with the Change a cell Action.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
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
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.
-
Hi
thanks for your answer but your solution is not what I need.
If a change in a second moment the value of the cell the collegues don't realize the change.
I would like to avoid from the beginning.
Umberto
-
Happy to help!
Not sure I follow! Can you elaborate more?
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!
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.
-
Hi, sure
I asked my collegues to set in the that column or 0% or 100% no different values.
If the activity is not ended they have to add a new row in a differet data, the previous must be completed.
If they insert for exemple 40% and i change the value in 100% as you suggested they will continue to do this and I will find an activity completed but isn't true.
NOT CORRECT
CORRECT
Umberto
-
Hi,
you could always add a drop down with 0% and 100% and lock the column so they can only choose one or the other.
Regards
Shaun
-
hi
no i can't cause I'm working in a menù and the column can't be set as you suggested.
The column in 7.0 line is auto filled for example... in line with how the aothers lines below are filled
Thanks Umberto
-
Tricky one! I don't think it's possible!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives