Best Of
Re: Smartsheet EVP of engineering, Praerit Garg discusses the importance of middle managers
The included article link is a good read! I like and agree with the steps that Praerit Garg outlined.
I am not the least bit surprised by the research results. Managers are the driving force behind their team and the outcomes are a direct reflection of their leadership. I recently delivered a training focused on developing others and the main topic was focused on Blanchard's SLII theory and the situational approach to managing people. It outlines the different leadership styles and how you can match that up to the development level of your people. At the end of the day the entire employee experience begins and ends with their manager.
We all can look at managers we have had that have made an impact on our lives. Whether it was positive or negative. Clearly the negative interactions are the ones that will demotivate. On the opposite side, you can consider that manager that motivated you to be your best. Looking at what that manager did to motivate you is the best example of what to do yourself if you are a manager. Motivating, inspiring and engaging people is not always an easy task but when you strike the right balance - the rewards are great in the end!
Sandra Guzman
Re: Registration now open! ✨ Join us for ENGAGE 2023: Potential unlocked
I'm so excited to catch up with @Alison Clancy, @Arsineh, @Claire Sternoff, @Kelsey Hayden, & all of the Smartsheet Overachievers! Hanging out at the community booth lets you meet so many people and hear how they are using Smartsheet.
The energy that comes from the conference is amazing, but I think my favorite is providing feedback to the Smartsheet product teams, then seeing some of those ideas come to life in the months that follow.
Jenn Hilber
How would I split text separated by commas into new cells?
Example, in one cell I have the text "Zach, Max, Prince, Bob, Rick and more"
How do I split that to have each name in each column, all on the same row?
sweta22
Re: Set Formula Column to Inform Dropdown Column
Hi @Laurin
I hope you're well and safe!
You could use Workflows combined with the change a cell Action to change the values automatically without any formulas.
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!
Andrée Starå
Re: Workflow History
The activity log for the sheet will give you some information. If it affects other sheets, their activity logs may also provide some insight.
Carson Penticuff
Re: How can I automate task creation?
Hi @CamSME
Notifying someone to either create the task or the process flow makes sense to me, without knowing too much more about your set-up.
@Andrée Starå's suggestion of copying a row would work well if you knew exactly what tasks would need to be done for each of the different instances/timings. You could have one sheet set up as a template with the different tasks, then when the person get's the alert they could select the appropriate tasks and copy them over to your active sheet. See: Copy and paste hierarchy
Please also feel free to submit a feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community, explaining your use-case and example. This will allow other users to vote on your enhancement idea!
Cheers,
Genevieve
Genevieve P.
Re: Counting selected dropdown elements with Collect function?!?
You would use a COUNTIFS with a HAS function.
=COUNTIFS({Agents}, HAS(@cell, Agent@row), {Elements}, HAS(@cell, "Robot"))
Paul Newcome
Re: Calendar App vs. Published Calendar View
I hope you're well and safe!
Here's a possible workaround or workarounds
- You could automatically update the options left using the Premium app, Data Shuttle.
- You could have a dashboard/portal with the form on one side and the options left on the other side.
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
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!
Andrée Starå
Re: Bridge Data Copy on checkbox = True help.
Hi @Coen
Your guess is exactly right! Since the checkboxes don't appear until there's content in the row, Bridge is likely reading the "false" value as a change and triggering the workflow. The trigger is looking for any change, which could also include colour formatting in the cell.
What I would personally do here is add a Get Row module as the very first step of the workflow to get the row that triggered the workflow, using the Runtime Event to reference it:
Then I'd add a Match junction to see if the value in the checkbox column is "True" or "False", simply stopping the Bridge flow if the box is false.
Then you can have the rest of your workflow follow on after the "true" side of the Match junction. There may be another way to do this, but this is what I would do!
I hope it helps,
Genevieve
Genevieve P.
Re: Formula for counting Invites and number of guests associated with that invite
Rather than use Sumif or Sumifs, instead, I would leverage Countif or Countifs
You can set multiple parameters on Countifs, which would count the total number of invites sent if you set a 2*(countifs) for the invites of 2 people.
and then, as an outstanding project manager, you can track the total RSVPs, by dividing the RSVPs by the total invites.
Sounds like a fun party, enjoy.
Andy Taylor