Best Of

Re: Admin Center - Form Security - Permission Inheritance - Downgrading

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.

1 ·

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.

1 ·

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.

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

View the Badge Dashboard

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

Try out our ENGAGE 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

@Colleen Patterson Here

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.

https://www.youtube.com/watch?v=rR1lgEMMJwo

The 1975, "Happiness"

"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.

13 ·

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

4 ·

Re: How can I convert a Local currency to USD in the Smartsheet Form.

Hi @Nateetorn Rakkhaphan,

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

1 ·

Re: QR Code and Forms

@StephanieStepney Forgot to mention It is also on the Smartsheet Marketplace: https://www.smartsheet.com/marketplace/apps/inline-qr-generator

MaaikMeijerink

1 ·

Re: QR Code and Forms

@StephanieStepney Perhaps our feature can help you: it is generating a QR code within a Smartsheet cell based on a simple formula: = QR(<column>@row), so without leaving Smartsheet at all: https://smart4b.nl/inline-qr-generator/

Just ask for the Trial, we will be happy to share a sheet with examples, so you can test it out yourself.

Regards, Maaik

MaaikMeijerink

1 ·