Best Of
Re: OR in COUNTIFS Formula
Remember that the syntax for the COUNTIFS function is COUNTIFS(range 1, logical statement 1, range 2, logical statement 2, etc etc etc.
{status}, OR(@cell = "Repaired", @cell = "Beyond Repair (BER)")
Here, {status} is the range, and the entire OR statement is the logical statement. @cell is referencing back to {status} in the range.
Carson Penticuff
Re: Automatically Delete Attachments when a condition is met?
Hi @Krys West - this is a good thought. Our organization has explored this before with a few other projects and at the time couldn’t find a way to make this happen.
You can add new versions of the document over top of previous versions - which solved our use case (but all other versions are still accessible if looking through the doc version history).
Re: Competency Framework
Hey @peter65516
Not knowing your sheet or data input process, I'm not sure if it would be necessary to move rows to another sheet (using built-in smartsheet automation) or if you could capture all the data in your current sheet. Each entry would be its own row, thus no trainer overwrites someone else's data.
A report can then gather the data per trainees and summarize the average. This report would be the source for your dashboard.
Would this work for you?
Kelly
Kelly Moore
Re: Numbering Parent Rows
Hey @Jeff Reisman ,
I found a Plan B to combine my new need and what you offered that I needed. Here are my formulas:
Auto Auto Numbering
Parent =IF(Helper@row = "Parent", Auto@row)
ID =IFERROR(RANKEQ(Parent@row, Parent:Parent, 1), "")
Helper - Last column to the very right, this is a Text field.
I hid the columns that are not relevant. I added the INDEX/MATCH formula to the Blue highlighted Cells in the Release column. This first screenshot is all formulas with exception of the final (Helper) column, which is in text and highlighted in Purple. The second sheet is my Release List. Rather than manually entering each Release into the first screenshot, the Release List lets me have a master list of releases, and the first sheet is updated completely by formula! Having that purple column in text is a small price to pay for the automation!
Sherry Fox
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