Best Of
Re: Import Data from AirTable.com
Happy to help!
Unfortunately, Bridge isn't available as an add-on on the Pro plan.
More info.
Yes, export from Airtable and then maybe use the below if needed to help with the import.
I'd recommend the fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
✅ Remember! Did I help answer your questions or solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. It will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: August Question of the Month - Join the conversation and receive a badge
Absolutely agree with the collaboration and the Community itself, but my favourite thing on this Community so far was the art challenge, and especially @Protonsponge's effort:
Still so impressed by everyone's Smartsheet art - you are all so creative, and all so helpful and encouraging to each other! 💖
Georgie
Re: August Question of the Month - Join the conversation and receive a badge
I also absolutely love the community and support as well, digging into formulas and the collaboration!
That being said, two solutions I have found for a couple of my problems that needed solving were these. So simple and (I thought) elegant!
Simple way to round to nearest 0.5 posted by @CanadaJim
And getting a Month Name is a column by @John C Murray
jjg279
Re: August Question of the Month - Join the conversation and receive a badge
The best thing for me about the community is how Smartsheet links the forum posts to the help center so we can check the provided resources, or we can quickly see if any other user has the same issue and if anyone shared how to fix it.
Being able to have that function embedded into the questions support has really allowed me to review the community forums even when I have a busy day and I have a problem I need to figure out immediately.
Thank you Smartsheet for bridging the gap between what you provide as resources and the communities support.
Amanda Winter
Re: August Question of the Month - Join the conversation and receive a badge
One of the best things I've seen, the games. It's cool to see the different types of games you can build in Smartsheet to further engage users.
Isis Taylor
Re: August Question of the Month - Join the conversation and receive a badge
I get my dopamin kick when I get notified that my answer was chosen as the best answer…
kowal
Re: Capabilities of "Viewers" in new Model
@SteCoxy pretty much. We're putting a lot of accountability with paid Members to understand the changes around sharing and permission levels that auto upgrade users.
My opinion is it's the System Admins where the headache of managing these users comes into play.
Like you we do not convert to USM until the end of September so are trying our best to hammer in all these changes in responsibility. It's a lot to retain and be careful of including permissions at a group level vs individual account level. All we can do is our best to educate, provide resources they can refer to at any time and track who acknowledges they've read and understand these changes.
Re: Importing Excel spreadsheet to an existing Smartsheet
Hi!
I’m Maria from the Product team at Smartsheet. I’m looking to speak to a few users with data import use cases, and came across your post here. Would you be willing to meet with me, to talk through your import needs, and your experiences of importing data with Smartsheet to date? We are working on improving the import experience for users, and your input would be valuable.
My email is maria.franklin@smartsheet.com if you’d like to get in touch to schedule some time.
Best regards,
Maria
Maria Franklin
Re: Using #IFERROR to display #NO MATCH as a usable automation
Hi @Ty Werven
Great question!
When using the IFERROR function, think of it like this:
IFERROR(successful_formula, fallback_if_error)
In your case, you're trying to match names from another sheet and return their "Attending?" status. If there's no match (e.g., #NO MATCH), you want to display "Not Found" instead — which is perfect for driving automation.
Here’s a sample formula that does just that:
=IFERROR(INDEX({RSVP_Responses_Sample : Attending?}, MATCH(Name@row , {RSVP_Responses_Sample : Name}, 0)), "Not Found")
What it does:
- MATCH(Name@row , {RSVP_Responses_Sample : Name}, 0) looks for the current row’s name in your RSVP sheet.
INDEX(..., ...)retrieves the corresponding "Attending?" value.- If no match is found (which would normally return
#NO MATCH),IFERRORreplaces it with"Not Found".
Re: Is there anyway to automate the process of moving an attached image to a cell?
Just in case others stumble on this section, I had a similar problem and used the API to solve this problem using python. The following code gets a list of attachments and moves them to designated column on the same row as the original by downloading them and the re-uploading them.
jjg279