-
Sheet Sharing Restriction Exceptions
Is there a way to have a setting on a sheet that would allow it to override the restrictions put in place for automated alerts going to email addresses that are not in our Approved Domain Sharing List? Here is our scenario. We locked down our Smartsheet sharing so that someone cannot share a sheet to someone that we do not…
-
What defines a "User"?
I'm pretty confused on what defines a "User" in Smartsheet. When I go to User Management section I can see a list of my users, currently 18. I know however that there are probably 60 people in my organization that sheets are shared to and they have edit permissions on those sheets. Why don't they appear as users? Where…
-
Creating a percentage from multiple tick boxes
Hi All, This may be simple but i'm struggling to get an output so hoping you can help... I'm trying to calculate a percentage based on the number of completed tick boxes in a row/column. I'd be ok if this initially does a count in one cell and then coverts to a percentage in another. This is the example data below:
-
Avoiding a massive nested IF formula - checkboxes?
Hi all, I have 5 check boxes and based on these being ticked or unticked i want to display something in another cell. It is essentially a decision tree that simply i want to work as follows: If Group 2 is not ticked (or nothing ticked) = Group 1 If Group 2 is ticked but 3, 4, 5 & Close are not = Group 2 If Groups 2 & 3 are…
-
How do I hide names in Gantt Chart?
I created a schedule and assigned task to the resources names. The names are showing up in the Gantt chart. How do I hide names ?
-
How do you create a contact list based on 2 seperate sheets using a Vlookup.
Hello, Looking for some assistance with an issue we are having populating contact lists based on 2 separate sheets using a vlookup. To summarize the attachment, we have a sheet with a list of account owners and their email addresses (Client Services Listing) that is feeding into another sheet (CSLS Teams by Account) which…
-
Is there a way to force a Dynamic View logout when the session ends?
Currently, it is possible to be logged in Smartsheet and Dynamic View under two different accounts, simultaneously, on the same machine. Unless a user explicitly logs out of Dynamic View or clears the browser cache, the next time Dynamic View is opened, the previous session is resumed. This presents a problem for shared…
-
Can I create one Smartsheet QR code that shows me a list of Forms to choose from?
Currently, my team has several different forms that we use to track process KPIs, or to populate other files. This means we have to post or carry around a handful of QR codes linking to those various forms. I'd much rather have one QR code to rule them all and show all the forms, click on one there and have it navigate me…
-
Expiry Dates - Compliance Check
Dear SmartSheet Community, I need your help. I need help in writing a formula that will track compliance for different areas based on expiration dates. If dates are active and will not expire in the next 30 days, health should be green. However, if one or more items in the row will expire in 30 days, yellow and anything…
-
How to reference another sheet in a formula
I've been trying to write a formula that will "Check a checkbox (in sheet A) IF [name] cell (in sheet A) is found in {name} column (in sheet B), AND the box in [checkbox] column (in sheet B) is checked." Basically, does a particular staff member's name appear on another sheet, and if so does it have a checkbox checked in…