-
Filters and collaborators
I have staff that are set with the correct permissions to edit the sheets, but they cant see my existing filters. Is there a way to enable that view that I'm just not seeing or do they just need to build their own?
-
Sending Alerts based on Business Days
Hello, does anyone know if it is possible to send alerts based on business days instead of only days? We are a M-F operation and will not respond to customers over the weekend. thank you
-
Apply an updated template to a group of sheets
I have a group of about 50 sheets which I created using a customized template. I need to update the template (add a couple rows, add conditional formatting) and am wondering if there is a way I can apply the update on a mass scale to the sheets I've already created. I really don't want to have to update each one…
-
Charts in Sights
Love the new chart widget in Sights. Thank you! Question: Why did you take away the custom colors for tabs in sheets and workspaces?
-
Sharing Sheets
All the tabs/sheets have greyed out and the sharing button at the bottom has disappeared.Also seems like my colleagues cannot access the sheets anymore, that I shared with them earlier.
-
Link sheets so when "checked" it adds to another sheet
Hello, Is there any way that I can use a check box to then add an item to another sheet? Thanks, Harrison
-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Determining Resource Allocation for Resource View
Hello! I am trying to find a way to determine resource allocation in project plans so that they more accurately reflect the availability of my team in the resource view. We have individual project plans for each project, which all feed into the main status sheet. Each project plan is broken down into tasks with…
-
Staff Widget Production Tracking
I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which includes invoices processed,…
-
Restricting access to certain rows
I have a smartsheet for travel requests within an organisation of about 2000 people. Each row contains the requester's e-mail and details about date, destination cost and purpose of travel. I then use formulae to display remaining budget, etc. to approvers. Within the organisation there are about 15 people who can approve.…