-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
Unable to transfer ownership of specific Smartsheet items
I used to be able to click share for a specific sheet and make someone a owner of a specific document. A few weeks back, the "Make Owner" option stopped showing up. Is there a reason this option was removed and what is the workaround?
-
Dynamic View Access
I've created a Dynamic view sheet for a couple of my partners and have added them as shared users but it doesn't seem like Smartsheet sends a notification once they are added as a shared user. How do they get access to the sheet and does it require they create a smartsheet account?
-
how do i update the 'action tracker' status column from the action tracker updater sheet
I want to make a system where not everyone can see my action tracker sheet. What can I do to ensure that the status column can be updated to whosoever the action has been assigned to without them having to see the full sheet
-
Admin Authorise change
Hi all, would it be possible to add in a feature so i can select a column which allows people with editor permission to change. However before that change is locked in, an admin has to check and approve the change. One of the main reasons we use smart sheets is the ability to lock columns and rows which is fantastic.…
-
Self-Update Solution - Enabling [outside] users to edit previously submitted content
If you host a set of records that "belong" to others, and you want them to be able to edit their records at any time, check out this dashboard as a seedbed of ideas for how you could achieve this. Please suggest other wording I could edit into in this title or entry to help people find this. I'm doubtful "self-update" is…
-
Parent Rows in Report
Hello, I have a made a current user report which shows only tasks where the current user needs to update. However I need the parent rows to show above the current user which may not be assigned to the same user. Is there any way to show parent rows in a report if there is filters that are applied which stop from parent…
-
Please enhance Column Contacts and Form Contacts by allowing Groups to be used!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
-
Newly Created Groups not appearing
I have created a few groups and added members over the last 24 hours - however when I attempt to share sheets or dashboard - they do not appear as an option. I have submitted a ticket - but have not yet heard back from support. Am I missing something?