Best Of
Re: Welcome to the Government Community!
Hello, my name is Virginia. I work at the City of San Diego as an Information Systems Analyst. I created our City of San Diego Smartsheet User Group and I lead our monthly virtual meetings. I've been using Smartsheet since 2019 and I'm still learning new things every day. Smartsheet used to be only a tiny portion of my work, but now I am in a role that has a 50% focus on it. I am looking forward to seeing how everyone here is using Smartsheet for process improvement and project management.
Re: Industry Talk - Connect with peers in your industry!
Hi @virgh,
I'm happy to share that we just added a new Government subtopic to Industry talk this week, and it includes Local Government! Hope you'll enjoy connecting with your peers there. 😄
Re: How do I add multiple check boxes in one column?
Hey @williamsons2,
In the form you need to make the field a dropdown rather than a checkbox (see my previous comment), then toggle multiple values per cell:
Then in the right hand side (when you have the field selected), click either the "Vertical Checkboxes" or "Horizontal Checkboxes" under "Display As":
Hope this helps!
Re: Counting people
=COUNT(DISTINCT(COLLECT([Employee]:[Employee], [Activity]:[Activity], "X")))
Re: Counting people
=COUNT(DISTINCT([Employee]:[Employee]))
Replace [Employee] if your column has a difference name. This will essentially generate a list of distinct entries and then count them.
Re: Bridge - Pull Multiple contacts from one sheet & update one cell with all?
The easiest way in my opinion to remove duplicates would be to use the javascript module, and write a short script to do this.
The trim module just removes the bottom however many number or array items you specify, doesn't look at duplicates.
ChatGPT is a great resource for quick javascript code.
also, multiple select contact has to be in a specific json format, so you may run into that as well.
Re: Is there a way to put a display name on a hyperlink in the Form Description?
I hope you're well and safe!
Yes!
You can select any text and then use the link tool to add a URL.
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!
Re: How to transform a Multi-select dropdown into multiple rows
You have encountered a limitation of Smartsheet, and I wish there was a way to make this happen.
You could create a sheet that has a row for each possible selection for each person, and then filter that sheet to only show records where the person selected that choice, but in my experience, these sheets quickly run into Smartsheet formula limitations.
But KPH also has a workable Idea, which is a column for each possible answer choice. Then you use a cross-sheet reference to populate the columns.
Re: How to transform a Multi-select dropdown into multiple rows
If you are comfortable using the API you can grab the new line and the write out a line for each entry in the choices column.
/marc
Re: How to transform a Multi-select dropdown into multiple rows
I hope you're well and safe!
Yes, it's possible, but it's pretty advanced.
I recently I developed a solution for a client that creates a select number of assignment rows with specific details from a defined start date that consultants use to report their work hours on a row per date.
Do you have a budget to bring in a consultant (like me) to 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!