Best Of
Re: Automation Question
Hey @Kris Peeters,
Can you add a snapshot of your automation?
My guess is that you didnt set a condition for which rows it should send.
When you set an automation to send when row changes, you also need to set a condition under it so it will only sent rows that are within this condition.
Hope that helps.
Itai Perez
Re: How to include default values for new tasks in a Task List?
Hi @BESSjd,
A couple of ideas for you on this one:
- If you want to have selectable contacts in a dropdown via a form, pre-populate 'Add contacts' box when setting up the column. These will then be available for people submitting the form to select from.
- For any formula-based defaults, if you add a helper column as an override, you can adjust your formula to pick up the override if it is populated, or go with the default if not. Something along the lines of: =IF(Override@row<>"",Override@row,"Default value").
Philip Robbins
Re: PDF to MYOB
Hi @Julieh
@Ipshita is referencing MYOB as if it's a specific User, however I believe this is a secondary software that you're looking to integrate with Smartsheet, is that correct?
Without knowing too much about MYOB, I believe you may be correct in saying you'll need to download the file to then send it in the correct format.
See: View and download attachments
Cheers,
Genevieve
Genevieve P.
Re: URL for a row of data
HI @alexis.ray89371 ,
Right click on the left hand side of the row (in the row number), then Properties. A small window will open with the Row Link as the last option. You can also click any cell in the row, row actions and then properties for the same result.
Hope this helps!
Nick Korna
Re: Introducing the 2023 Core Product Certification Exam + Community Badges
Hi @Arsineh I passed my core product certification exam on July 28. The badge is in Credly but it is not showing in my profile yet. Do you know when I can expect to see it? Thank you
Greg_Lea
Re: Count if all, cells contain a specific word.
You'd change the formula to COUNTIFS and add in the extra column(s) & criteria. That the other column's value is calculated rather than directly input shouldn't matter.
If you're looking for a single text value, then you can just use "text" as the criteria, or use CONTAINS in a similar way.
Nick Korna
Re: Customize the From Name of Smartsheet Alerts and Requests
This isn't really what we asked for. We want to be able to customize the sender name/email. We would like for the notifications to be sent from, and responses to go to, a specific email address. This is often a shared email box that can be accessed by multiple people, rather than sending tons of emails directly to an individual (who may or may not have anything to do with it, they only created the sheet).
This is definitely a step in the right direction but seems like a halfway fix being wrapped up as the solution we wanted, but it isn't.
AmandaWebb
Re: If statement referencing another sheet returns invalid operation
@pdv90 Your formula isn't working because you are comparing an array to a single cell. You can try the following
=IF(CONTAINS([Cutting Room Number]@row, {Master Bookings Sheet-V2.0 Range 1}), "Unavailable", "Available")
Eric Law
Re: Mass email automation for meeting a criteria
@mahmadi If you have the same email in a cell that it sends to, it should be sent to them in a list form, example below.
Eric Law
Re: Web content pages in WorkApps
Hi @Jclifton
Here's an article that you may find helpful:
For Youtube, you need more than just the URL, you'll need to get the Embed Code - the steps are linked in the article above.
In regards to adding a Teams Channel, I don't believe this is a type of web content that can be embedded, but I'd love to be proven wrong! Enterprise plans can allow specific company domains as supported sources for the web content widget (and Workapps) by validating those domains and checking the Include domains box. (See: Admin Center: Set security controls for your account) I'm not certain that the Teams link counts as a "company domain" but it's worth a try - let me know if this worked for you.
Cheers,
Genevieve
Genevieve P.