-
Centrally Manage Drop Down Lists for Multiple Sheets
I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have to edit drop-down lists manually sheet-by-sheet. I've searched the community for ways…
-
Match Statement with Multiple Sheets
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO") I have another sheet…
-
Sharing a Folder in a workspace
How can I share a folder with specific people in a workspace while limiting them from seeing other folders in the same workspace?
-
Access permissions problem
Over the past couple months there have been a few occasions where we have seen users with permissions to access (view) a resource calling to say they were no longer able to access and given an error: "You don't have access to this item" To correct the problem: I tried deleting their name from the share list. Wouldn't…
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Expand/Collapse all functionality
I have set up a hierarchy within several sheets and I'm wondering- is there an Expand all/ Collapse all functionality for the 'nested' rows of data? Refreshing the page doesn't change anything within the sheet that is shared across 4 users. Mendy
-
Alerts - Notifications to Groups
Is it not possible to set up a Notification alert to be sent to a Group? I only see the ability to send them to individual users.
-
Check Multiple Boxes or Tag Multiple Items Within One Cell?
I know I've asked this in the past like 3 years ago but don't know if there mght have been a feature update or workaround for this yet. Is there a way to check multiple boxes or tag multiple items within a single cell? If I made a dropdown menu of 12 items for example, is there a way to check or select 2 of them for one…
-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…
-
Assigning Multiple Tasks to an Entire Team
Hi I am new to Smartsheet, and hence am unable to perform the subject activity in it. I have a set of 25 tasks called "Proofreading Tasks". And I have around 15 people in a team which is called "Team - Proofreaders" . This team is supposed to perform these -- and only these -- tasks. Now how do I set it up in Smartsheet so…
