Best Of
Re: Automation to change cell which has drop-down values does not work
Certain automations can not be triggered by a change to a cell which gets its value via a cell-link (formula pulling from another sheet.) I believe this includes the Change a Cell Value and the Record a Date automations.
Instead you may consider setting the value based on a time trigger. Set the trigger to be "When a Date is reached," select custom, and set it to run daily at a specific time (maybe end of the day or beginning of the day) to update your Current Status column to reflect the value in the Project Status column.
Jeff Reisman
Re: How to Count the Number of times a Value Appears in a Column in Another Sheet
Hey @bhammond
Thanks for clarifying that it's multi-select! The quotes are looking for an exact match. If you need to look for one selection among others, try the HAS function to search for if that cell has a specific value along with others, like so:
=COUNTIFS({On-Site Event Request Range 3}, HAS(@cell, "Networking"))
Cheers,
Genevieve
Genevieve P.
Re: Help with how to sort data, summary, report, formula?? Not sure
Would recommend doing a helper column with a count if any of those row are checked, then doing the filter off, is less than or equal to 3.
=COUNTIF([Left most column name]@row:[Right most check box column name]@row,1)
This will sum all of the checked fields into a single digit.
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