Auto-populate symbol field
Can you auto-populate a symbol field based on criteria? The change looks like this:
Any new row added will have the Risk symbol automatically changed to the green circle/dot.
I've tried doing the change a cell workflow, but it won't allow me to change the Risk/Symbol column.
I hope that makes sense.
TIA!
Answers
-
Do you currently have a formula in that column?
-
no sir, no formula in that column
-
I hope you're well and safe!
You could add a so-called helper column, in which you'd change the text value and then reference it in your Risk column.
Make sense?
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.
-
I just tested, and it looks like you cannot use the Change Cell automation on Symbol Columns. Are you wanting this to be manually changed in the future (after the row has been created), or are you able to provide logic for each of the other colors and maybe we can come up with a formula for you?
-
When a new line is added, we want to populate the Risk Column with Green. Then after, it can be changed manually by the user
-
You cannot unfortunately change a symbol type column through a change cell automation. How exactly are new rows added?
-
they come in via api
-
In that case you would need to have it written into the API or manually change it to green on all rows.
-
ok, thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives