Best Of
Re: Dashboard Custom Background Colors | Closely Align With Your Brand Colors
How long until Smartsheet allows us to create custom theme's I wonderโฆ There's a lot more in a dashboard than just the background colours.
Ryan Catling
I'm building a form which will ask for an address.
Can the USPS validator tool be integrated?
Jessica 4840
Re: Introduce yourself & get to know your peers!
Hey there! My name is Marlei' and I work in WA State government. As the Smartsheet Administrator and SME for the agency, most of my time is spent creating, maintainting and troubleshooting Smartsheet solutions. My favorite component of Smartsheet has to be WorkApps. Love that I can put many resources together for individuals & teams to have at their fingertips!
I am a mom of 6 adult children, have 2 grandchildren, 2 godchildren, and 4 dogs. Oopsโฆ almost forgot, a husband too :) As a family we love to camp, play games/sports and travel. Leavenworth is our favorite holiday family getaway.
Picture: Kona & Kali - Frenchtons (French Bulldog/Boston Terrier)
Marlei
Re: Create a list in one column from multiple columns
Hi @jrlschumacher !
I would use a combination of IF and ISBLANK statements like the following:
=IF(ISBLANK([BC?]@row), "BC", "") + ", " + IF(ISBLANK([IMM]@row), "Immunizations", "") + ", " + IF(ISBLANK([OE?]@row), "Open Enrollment", "") + ", " + IF(ISBLANK([SCRN]@row), "Screening", "")
The comma between each statement will allow it to read as a list rather than a run on word.
Hope this helps!
AKnight
Re: Create a list in one column from multiple columns
You would need a series of IF statements strung together.
=IF([BC?]@row = "", "BC, ", "") + IF(IMM@row = "", "Immunizations, ", "") + IF([OE?]@row = "", "Open Enrollment, ", "") + IF([SCRN?]@row = "", "Screening", "")
Paul Newcome
Re: January Question of the Month - Join the conversation and receive a badge
Something on my bucket list would be to refurbish a dilapidated building and turn it into a house.
AnthonyxXx
Re: Referencing/Adding values from multiple cells in a sheet and inputting in another
I think you'd like something like below. To join text values, you can use the JOIN function, and the COLLECT function is used to only join the values based on specific criteria (in the case below, the "Summarize Date" field I made). The CHAR(10) is a special character function for line break, so you can see the formula returns a break between each value for the date.
=JOIN(COLLECT([Issue Description]:[Issue Description], [Date Issue Occurred]:[Date Issue Occurred], [Summarize Date]@row), CHAR(10))
To join values, you can use the SUMIFS function. Same general principle as above, but we are summing values instead of concatenating them.
=SUMIFS([Length of Critical Path Delay (hours)]:[Length of Critical Path Delay (hours)], [Date Issue Occurred]:[Date Issue Occurred], [Summarize Date]@row)
*Note that for joining descriptions, you'll still have the 4,000 character limit per cell.
Jason Tarpinian
Re: Dark Theme - or other options - via User Options or Workspace Options
YESSSS!!! Please x 10000 let's get DARK MODE - I also use the Dark Reader add on for Chrome, but it does NOT work so well when color-coding is a big part of your smart Sheets formatting.... Please prioritize getting Dark Mode onto the Smart Sheets app - you know another online spread sheet does this or will soon and then you will lose all our business to that app - your app without the dark mode is killing my eyes!!! thank you for considering it!
SunshineCafe
Re: SharePoint embed in WorkApps
I second this, I was very disappointed to attempt and learn that it was not achievable. Based on a segment at the Smartsheet Engage conference, one of the best ways to implement Smartsheet is to allow our users to use the tool without knowing they are in a separate system. This makes it a challenge to publish something such as a Word Document (published in SharePoint) or even a SharePoint site. I am using WorkApps for a project plan and I need full integration of the tools.
Desiree.Gonzalez
Re: Index IF formula for data in Row bases on Column data
Hello @Marielitos
If you're going through the path of using formulas, you'll need to create the formula on each column on your destination sheet. Also, I think you'd want to use INDEX/COLLECT functions instead of the INDEX/MATCH since you have the criteria of Yes/No.
So something like this for every column:
=INDEX(COLLECT({Column X},{Unique Identifier},[Unique Identifier]@row,{YES/NO Column},"Yes"),1)
Another easier way is just to do the automation and copy the row when the Yes/No column is equal to "Yes". Formulas and cross sheet references won't be copied over to your destination sheet only the values/ data will be copied over.
Melissa Yamada