Best Of
Re: I need help implementing the "OR" function for a SUMIF scenario
See below proper syntax for using the OR() function
=SUMIF([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved"), [Total Deal Value]:[Total Deal Value])
Leibel S
Re: Badge Inquiry
Hi @Bobby Kennedy,
These badges will be assigned in the next few days, so you should be able to see it on your profile soon!
Rebeca S.
Re: Select specific person/email as the name for automated alerts
Unfortunately, the proffered solution only only changes who is listed as sending the email. The email headers still include a Reply-To field for the sheet owner. This addresses the concern of Smartsheet notifications looking like spam but does not really help the original issue of people responding to the sheet owner and not the right people in the organization. We need the ability to specify the reply-to address.
katheride
Re: Automations: include attachments
Hello everyone,
I discovered a type of work around that may assist others that want all attachments for a row to be sent out with an alert even when the attachments were linked to the row at different times by different users.
My workflow (automation) contains update requests that retrieve attachments from multiple users and once complete a document (PDF) is generated. I needed all the attachments + PDF to be sent to the affected users in (1) final email. We accomplished this by creating a 2nd sheet and once all the operations were complete on Sheet 1 we created an automation for when the last attachment was added (Generated PDF) it triggered the row to be copied to the 2nd sheet. Then on the 2nd sheet another automation was setup to be triggered upon attachment "added" and to alert users and include links to sheets (and attachments). It seems Smartsheets sees the copied row to sheet 2 as having new attachments and thus an email alert is sent including links to all attachments in the row! 😊
I hope this helps someone as it was frustrating for me while trying to design my Change Order work flow and not having the ability to include all row attachments in the alert if they were added at different times.
Have a great day!
Nicktbss
Re: How to count date occurrences within a month
Hi @Merritt R,
The criteria should not be in the quotation marks as this will mean the COUNTIFS is looking for that as text, rather than as a function.
However, checking this you'll get an error. You can get round this easily though:
=COUNTIFS({*MASTER TABLE* Range 4},<>"",{*MASTER TABLE* Range 4}, MONTH(@cell) = 9)
Since your relevant values will have both a month of 9 (for September) and not be blank.
Hope this helps, but any problems/questions just ask! 🙂
Nick Korna
Re: Portfolio Dashboard - best way to showcase multiple phases within each project
You could use a report to filter projects, group, and/or sort them based on any criteria you can think of, they are extremely adaptable.
The tricky part is how you want to handle projects that are in multiple phases at one point in time. This is a question only you can answer based on what is the most important info to prioritize, but there a lot of options most likely.
Let's say you have 5 phases in your project lifecycle. You could use a sheet summary report which a checkbox (or some other visual) for each phase. Based on the Sheet data the boxes could automatically check/uncheck as a project enters/exits a phase. This report could then be on a dashboard and you could see each project with checkboxes for the phase(s) it is in.
You could use metric widgets to show the number of projects in a given phase, and when you click those you could go to a report that lists them.
Depending on how much complexity there is in your phases (# of phases total, # of simultaneous phases) you could have a report that is grouped by each phase or each combination of phases and lists them. For example it could start with whatever is in phase 1, then phase 1 & 2, phase 1 & 3, etc. This may or may not be practical with the data you have.
So it comes down to what information is important to communicate and then determining how to do so with the tools at your disposal.
Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)
Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
Smartsheet Tutorial Videos: schoolofsheets.com/youtube
Re: Add a formula column to multiple sheets efficiently
Happy to help!
More info on the API.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Count if Expiration Date is in the next 3, 14, 30 Days without counting Past Expiration Dates
The easiest way would be to create a helper column for the days remaining until the expiration date and reference that column in the function.
=COUNTIFS({Expiration Date}, <TODAY(3),{Days Remaining}, >0)
MichaelTCA
Looking for ENGAGE Virtual Activities? Find them all here!
Hey Smartsheet Community,
ENGAGE is just around the corner, and there’s so much to look forward to. Not attending? We’ve got you! 😎 We prepared a series of virtual activities for you to join the fun from wherever you are in the world.
Don't Miss Anything
Keep an eye on the Events Topic, the place to be for all things ENGAGE, and make sure to follow the official ENGAGE hashtag, #SmartsheetENGAGE on all of our socials. Don't forget to use the hashtag when contributing to the conversation! Read on to learn more.
ENGAGE Keynote Livestream - Tuesday, Sept. 19 | 9:00AM - 10:00AM PT
Tune in to the day one keynote livestream on the ENGAGE site, or catch it on our LinkedIn or YouTube channels. Can’t make it on time? No worries, you can still watch it later on any of these platforms.
Virtual Booth Games
Do you love playing games and earning badges? Check out the Community Virtual Games Dashboard, full of ENGAGE exclusive games 🤩
Community Feud - Can you guess the most popular answers to each Question of the Month?
Smardoku - Unleash your inner problem solver as you strategically place Community badges to fill the grid. Can you conquer this challenge?
Note: this game requires a Smartsheet license as it creates a sheet in your account.
Smartpardy - Showcase your Community expertise, and compete in the ultimate game of facts and trivia.
Meet and Eat Sessions
The conversations might start at ENGAGE, but they’ll continue in the Community! Share your insights, read the highlights from the moderators, and keep the discussions going on each of the prompt’s posts.
- Prompt 1: Share experiences about driving Smartsheet adoption at your company, including successes, challenges, tips and more.
- Prompt 2: Share how you use or hope to use the Community platform to achieve more, as well as stories about connecting/collaborating with other passionate Smartsheet users at work, at events or out in the wild.
- Prompt 3: Share what part of ENGAGE you would like to take part in the most, and/or positive experiences from years past.
Countdown to ENGAGE
Have you tried out all of our countdown to ENGAGE activities yet?
- Customer-Created Solution Contest - Submit a great solution for a chance to win unique prizes, your very own customer story, and to have it published as a template in the new Template Gallery.
- Smartsheet Travel Diaries - Share a photo from your corner of the world to earn a special badge + participate in a giveaway to win a Smartsheet travel kit.
- ENGAGE Official Playlist - We made the playlist for the event with YOUR suggestions. Have a dance party at home, and share a selfie dancing to your favorite song!
Which of these activities are you the most excited about, and which ones have you tried out so far? Let us know in the comments below.
Rebeca S.
Re: How to pull data from another sheet based on a specific criteria
@ERinaldi So, unlike a vlookup, index will always look at your first column of the range. You will need to create a new range for the index and it should work.
Eric Law