Best Of
Re: How can I reference a date from another sheet when writing a SUMIFS formula?
Hey!
In your Existing Ticket Tracker Sheet, my suggestion is to set it up with a buddy column called "Ticket Closed", if possible, because it will make writing the formula on the new master a little easier/future proofs it a bit, if you ever want to count other durations - ie quarters, months, etc. If you cannot, scroll below.
The Ticket Closed Column is a checkbox. It will be a Column Formula with this formula (see below).
=IF([Date Closed]@row <> "", true)
In your new Master Sheet, assuming you added the Ticket Closed Column. You can write your formula to say "Count if the "ticket closed column" is checked and it happened TODAY"
=COUNTIFS({Existing Ticket Tracker Sheet: Ticket Closed Colum}, true, {Existing Ticket Tracker Sheet: Date Closed}, TODAY())
If you want it between certain dates you and duration and just adjust the back end of the formula instead of saying "today"
Alternative Option: If you could not add the extra column, in the new sheet - use this. It will count how many tickets were closed using the date column.
=COUNTIF({Existing Ticket Tracker Sheet: Date Closed}, TODAY())
Let me know if this is what you were looking for! Thanks!
Julia Bennfors
Re: October Question of the Month π Join the conversation and receive a badge
Distancing from a toxic family member. Emotional abuse is hard to identify when you are going through it. You want to believe that, its just their personality and they really dont mean to be that way. It took several years after the distancing for me to realize that this person made choices to behave the way they did. Removing the close connection enabled me to minimze the negative interactions and I was able to focus on more positive relationships. In more recent years, I've rekindled a little of the closeness with this person... but only with clear boundaries of respect and positive intent. Life is good!
Marlei
Re: October Question of the Month π Join the conversation and receive a badge
Going on vacations by myself! Now I love just spending quality time with my own company around the world, however, I can't ignore that I have also met some wonderful beings in this journey π
Marcela
Re: October Question of the Month π Join the conversation and receive a badge
I was terrified the first time I was an announcer for a roller derby event. Normally I would never have been asked but volunteers were low that day so I stepped in. Public speaking and explaining a confusing sport to a group of 400 people was a bit much but got through it and I have picked up the microphone quite a few times since.
Amanda Jeske
Re: October Question of the Month π Join the conversation and receive a badge
Fear and scared of Height.
Aldrin Sarsaba
Re: Admin Center - Form Security - Permission Inheritance - Downgrading
Hey @Jonathan Hebert
To answer your last question - yes, that's correct and what I was wondering about.
Restricting it to people with a Smartsheet account still means anyone with a Smartsheet account could view the Form. The could create a free trial or be a part of a different plan and see your sensitive dropdown items.
I would potentially suggest adding those sensitive forms as an embedded Web Content widget in a Dashboard. Then you can either just share the Dashboard directly to specific groups/people, or use the published Dashboard link that restricts it to users in your Domain.
The embedded Form URL will only be accessible to users shared to the sheet or to the Dashboard with Admin permissions.
For your first question, you're correct - there currently isn't a way to see a list of all forms in your organization from the Admin Center. You can download a Sheet Access Report which identifies all the sheets, but not forms.
That said, you could use the Smartsheet API to List Sheets, then loop through the Sheet IDs to Get Sheets, with the parameter of include=publishedFormContainers . This would only get information for all the sheets that your specific account has access to, so if you're not shared to the sheet with the form it won't be included.
If your orgnaization has Event Reporting you could get notified every time a new form was created as well.
I hope that helps!
Genevieve
Genevieve P.
Re: Admin Center - Form Security - Permission Inheritance - Downgrading
Hey @Jonathan Hebert
Thanks for waiting!
So here's what I found in my tests:
- If the default initially requires access then gets downgraded, any forms that previously required access would now allow anyone to access (default adjusted)
- However, if any form had required the logged in user to also be in the safe sharing domain, they'd still require login and for the logged in user to be on the safe sharing domain.
You noted in the first post that you have forms with sensitive dropdowns. Are those forms restricted to any Smartsheet account in general, or your safe sharing domain?
Genevieve P.
ENGAGE recap & more: Community Corner Newsletter [October 2023]
Hi Smartsheet Community, I'm Rebeca from the Community Team. I'm excited to let you know that from now on, this newsletter will be available every month!
Big shout-out to Genevieve for an amazing newsletter in July. π And now, let's get into all the highlights from the last couple of months, ENGAGE, and learn a bit more about me at the end of the issue.
---
Community highlights
Help us welcome some of our newest Member introductions in Show & Tell or look through the Trending section for more ways to connect.
Say hello to these Community Members ππ»
Popular ideas & feature requests (reviewed by the Product Team)!
What's it going to be? Head to the Smartsheet Product and Ideas Topic to share and vote on ideas.
- Increase sheet row and column limits
- Add Work Insights to Dashboards
- Chart Labels: drag labels overlap & stacked column labels
Make sure to check out everything that we announced at ENGAGE!
---
Community Updates
In Case You Missed It (ICYMI)
Meet our Sponsor X: Girlstart
Join the conversation to earn a new badge
October Question of the Month
Share your answer by October 31
ENGAGE Attendee Badge
Smartsheet Travel Diaries + Giveaway Winner @W Straubhaar
Check out the amazing photo submissions
Smartsheet ENGAGE 2023 delivers style, efficiency, and scale
Learn about our upcoming innovations
Community Virtual Booth Games
Three Factors To Consider When Evaluating A Tool For Scalability
Learn about scalability from Praerit Garg, Smartsheet Chief Product Officer and EVP of engineering
Ambassadors & Leaders
Up leveled recently? Keep an eye out for the group invite soon!
---
Pass the mic π€ Community Champions
Community Champions are members who demonstrate product expertise and generosity in sharing best practices and support with others on the platform.
"A lot of my Smartsheet knowledge has been self taught, but leveraged from experts in the Community and from other industry leads. Watching YouTube content and communicating on forums has helped arm me with tools to quickly and effectively complete work. I also love hosting and attending User Groups!"
- @Chris Mondeau, Strategic Solutions Manager at Optimum Consultancy Services
---
Member Appreciation
See Activity feed for more
This month's leaderboard
Member spotlights
Meet Top 3 ENGAGE in-app Scavenger Hunt (And our raffle winner!)
---
Overachiever's Motivation Mix
The Smartsheet Overachievers are here to give you the songs that will keep you going and keep you achieving! Here's what's on the playlist right now.
"Each time I hear this song, I feel like I've rejuvenated my love for rediscovering and reveling in the brilliance of something or someone. That's what this song is all about! To take a moment to stop, dance, and say 'my my my' just makes it! It's impossible to not at least bop my head. Or maybe I just love 'my my mys' because I also love 'My My My' by Troye Sivan."
- @Andria Hoyle, Material Planner II at Seagen, United States
---
More about me
Hey there! I'm Rebeca, the Engagement Specialist in our Community. You'll usually see me in announcements, greeting new members, commenting and responding to your questions.
A few things about me:
- I've been a part of the Community team since the end of May, and I've loved getting to know youβand your excellent musical taste!
- I love reading + organizing, so I have a lot of fun keeping track of my growing book collection with Smartsheet.
- Outside of work, I like to spend time in nature, visiting new places, books and music.
- I'm Costa Rican, and greatly enjoy exploring my country. Check out the T-Rex I found! Jurassic Park was in Costa Rica, right? π
π My favorite tip
There are badges that are easy to get, but that you might've missed. Check out the Badges Dashboard, and explore them all! If you use Brandfolder, add this one (+ some extra points) to your collection in just a few minutes. π
Until next time!
Rebeca
---
Give us your feedback
Have ideas for the next Community Corner? Leave your thoughts in the comments!
Note: Unfollow this Topic if you'd no longer like to receive alerts. We'll miss you!
Rebeca S.
Re: Add 'sort order' to Filter Views
This is a big missing feature. Trying to convert Excel users to Smartsheet, then explaining you can't sort a filtered list always feels like a backward step and impacts adoption for us.
GrantKiwi
Re: How can I convert a Local currency to USD in the Smartsheet Form.
I use a lot of forms where the person filling out the form enters the amount and then chooses which currency. You could do something similar.
On the sheet, I have a helper column that pulls in the exchange rate previously entered into a separate metrics sheet, and then it will autocalculate it into the main currency that I need (USD).
I get the exchange rates from oanda.com and enter them manually into the metrics sheet, and then Smartsheet does the rest.
This is what it looks like on the metrics sheet:
And this is what it looks like on the sheet where the form entries show up:
The column "Exchange Rate" column uses an INDEX MATCH formula to pull the exchange rate from the metrics sheet.
The "USD Equivalent" column is a formula to convert it into USD.
LizTo