Best Of
Re: [RECAP] The Power of Authenticity in the Creator Economy
Such a good episode! Feeling very inspired.
Alison C.
[RECAP] The Power of Authenticity in the Creator Economy
Hi Community,
If you've ever been curious about the creator economy, this episode of the Brand Collective podcast is exactly what you need.
Meet Jamie Chicoine Chartier and Lucrèce Sicat Loe, Amazon Europe’s Head of Creator Marketing and Head of Influencer BD. Their combined expertise makes them the perfect guests to introduce us to this fascinating world!
Here’s what you can expect:
- Find out why keeping it real matters to content creators’ growth.
- Learn how niche branding helps creators stand out, spark connection, and grow communities that care.
- Unpack the global differences in the creator economy, from audience engagement strategies to brand partnerships.
🎧 Join the conversation. Name a creator that truly feels relatable and authentic to you.
On the episode, Jamie and Lucrèce share many reasons why customers trust creators who are honest and human. Think of the content creators you enjoy — Who is a great example of those characteristics?
Happy listening!
---
Want to check out more Podcast Recaps? Find them all here. ✨
Rebeca S.
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