-
Is there a way to send an Update Request to multiple contacts, but only accepting the first response
I am trying to put together some workflows where an Update Request is automatically sent out to a team of 3 people, but that only requires one response. I am hoping to avoid the unnecessary time/labor of more responses than are necessary.
-
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…
-
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…
-
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?
-
Creating a Report
Can I create a report, share it and restrict the user from seeing the SmartSheet?