Best Of

Hi @KaitlynB

Do you want to prevent users from accessing the sheet for which the forms are created? I think you can not. The shared users can still access the links to forms in the image. The forms are what you give users to add data without having access to the sheet.

You can hide the "Link to Form" column and show the link field with a formula when a checkbox is checked. However, you need to lock the checkbox column so that only you can check it when you need to access the form.

The [Link to Form] column has this formula;

=IF([Show form (Lock This Column)]@row, [Hide this Link]@row)

Publised demo sheets

The link below is link to the read only published sheet. So, it is equivalent to locking the [Show form] column. No one but you or admin can not check the column to show the link.

You can check the 2nd row to show the link to the form, as the link is to the published sheet that anyone can edit.

Hi @KaitlynB

You can use the "Link from Cell in Other Sheet" menu to create a cell link-in from a sheet to which no one but you has access. That way, your users can access the form links but cannot edit the links themselves.

Link from Cell in Other Sheet menu

The link below is a published sheet that anyone can edit. You can see that you can not edit the links as they are the link-in-cells.

Hi @David Valentine

Dashboards are different than other Smartsheet assets as they only have two sharing levels: Viewer or Admin. Editing a Dashboard is an Admin action since the user is creating new items (e.g. adding a Chart).

Here's more information: https://help.smartsheet.com/articles/2289957-sharing-a-smartsheet-dashboard#toc-share-a-dashboard

The Guest seat type can collaborate within Smartsheet, but this is limited to editing and commenting and does not allow for net new creation. Think of it as having the same permissions as the Commenter or Editor sharing permission level. Even if you grant a Guest Admin permissions on a sheet, Guests Seats are restricted to Editing type of actions.

Since changing a Dashboard requires Admin permissions, the Guest user will need to be upgraded to a Member seat type in order to create widgets.

Cheers,
Genevieve

We are a small, unpaid volunteer group working with sensitive data. We are currently in the midst of a humanitarian crisis in our community. In order to get the functionality I needed, I upgraded to a business account which required me to pay for 3 business level memberships (over $800) so that I could get the features I needed. Out of desperation, I shelled over the funds. Now I can't add my other volunteers as guest users apparently??!!!! I need to add them as provisional members and then downgrade them!? That is absolutely BANANAS. I am so frustrated I am in tears.