Best Of
Re: Extracting email information from a contact column
I've actually done this before, but it requires creating three helper columns.
First, create a duplicate of your contact column (let's call it "Helper-Contact"). Then switch the properties from contact to text. All of the contacts would then change to NAME <EMAIL> format.
Then, create a second helper column (we'll call it "Email") with text column properties.
Then, you'd create a third helper column (the times I've used this formula, I just call it "marker").
You'd then use the below formulas to pull over only the email from the Helper-Contact column as it's written within the <> into the Email column as text.
Formula for the marker column: =MAX(FIND("<", [Helper-Contact]@row), 2)
Formula for the Email column: =IFERROR(MID([Helper-Contact]@row, marker@row + 1, (LEN([Helper-Contact]@row) - (FIND("<", [Helper-Contact]@row))) - 1), "")
Lauren Dominique
You can search for forms now!
Hi Everyone,
In the pursuit of more thorough, robust search returns, we’ve made it so you can now search for forms. Previously, forms were not included in Smartsheet Search results, making it hard to quickly find a form you could fill out, share with others, edit, or view form responses. Addressing this was a top customer request. We hope you appreciate it!
In the pursuit of more thorough, robust search returns, we’ve broadened the range of “assets” you can now search. If you have access to the underlying sheet where the form submissions are deposited, you can now find the form using Global Search!
This applies to all plans and user types. Learn more here.
You can also stay informed by Subscribe to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Cheers,
John Hieger
John Hieger
Re: May Question of the Month - Join the conversation and receive a badge
My awesome account team @Sheena Tratz & @Katy Kellogg got me here and it's been exciting every since! Forever grateful <3
Martha Hemingway
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
Thanks for the quick feedback @Will Jeffords and @brianschmidt. I'm going try that. I did change the settings to unrestricted on the automation, so I will double check my email column.
Isis Taylor
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
Yes, this is possible. You will just want to be sure the column collecting the email addresses is formatted as a contact column. Additionally, in your workflow settings for the sheet, you'll want to select "Unrestricted" to ensure unlicensed, unshared email addresses can be sent those requests.
brianschmidt
Re: Collect Multiple Row Data into a Single Cell Reference
Hi @KThordarson,
This should give what you are after.
=JOIN(COLLECT({PTO}, {Name}, HAS(Attendees@row, @cell)), " , ")
Hope this helps,
Dave
DKazatsky2
Re: Smartsheet Forward Q2 2024: New ways to unlock actionable insights
Thanks for sharing Ben, these enhancements are really exciting! The AI integration is cutting-edge and that new timeline view looks really clean.
Will Duplex
Re: Internal Smartsheet Department
Thanks @A.J.
That makes a lot of sense and sounds like a good place for us to start.
Isis Taylor
Smartsheet Doc / Page / Wiki
It would be so awesome to have a "Dropbox Paper" or "Notion.so" type of markdown doc in smartsheet. Not all information should be on a sheet.
The combination of a wiki markdown page + sheets would mean that much more work could live in smartsheet instead of having to bounce between multiple tools.
The main issue with multiple tools is data integrity. Having all that data linked inside smarsheet would be ideal.
Adding this to the "create" drop down would be the ideal UX.
Joseph Estes
Re: Introduce yourself & get to know your peers!
Hello,
I'm Nicolas, from the South-East of France. I'm learning to use SMARTSHEET for 2 weeks. This is my first comment in this comunnity. I will first look for information. Thanks to be part of this community.
Nicolas Goulinet
