-
How do I get a sumif working with two date columns as comparison conditions?
Trying to get this formula to work but kind of new to Smartsheet. =sumifs(metres:metres, completed date:completed date, @cell<required date@cell) I don't know I should be using a flag column, there's already a fair bit of data knocking around and I would rather just get this to work for the sheet summary field.…
-
Sheet Connection
scope: I have several states working and adding every day into smartsheet sheets, those sheets are required to be seen / reviewed by the state managers, out of this information I want to create a daily updated sheet from this on a master sheet for CEO level. Client requirement: to see an overall update daily with the new…
-
Webinar Recording Available: Manage Projects with Smartsheet
Missed the webinar? Review the recording in the Learning Center. New to project management? No problem! Smartsheet makes it easier, no matter what size project you have. In this webinar, you'll learn best practices for simply and flexibly managing projects in Smartsheet, including: Structuring your project sheet…
-
Dashboard automatic updates
Hello, I am looking for a way to send a weekly message to a group of shared users to view the team's portfolio dashboard. Currently I have a scheduled report that is sent weekly, I want to do the same with the dashboard. Thanks Michelle
-
Filter for Assigned To in multiple columns
In my sheet, I have a few columns of assignments for different tasks. Is there a way to create a filter which will show any row that has a specific person assigned, but also must have a Check Box checked, in a specific column? I know there is the At Least/All toggle, but I'm looking for something that will offer an option…
-
Filter by Week
Hi, Relative newbie here. Im creating a smart sheet for the maintenance planning and scheduling at my work. The idea is that once jobs are planned they can be added to the sheet, and with filters made set by week number IE week40....... Easy enough The problem I am having is if a task duration is 3 weeks long as an…
-
Parent status (RYGB ball) changing based on child status (dropdown)
I am looking for help with a formula where I have a parent row and then multiple children rows below. The Parent has an overall status that is a 4 ball symbol of red, yellow, green, blue) My child rows are using a dropdown menu called "Confidence" with percentages as the values (10%, 20%...100%). I'd like to set the the…
-
Opening Dashboard Hyperlinks in new tab.
The dashboards that I've created for out Project Management teams contain a report that lists all their active projects with a hyperlink to a project schedule (A different Smartsheet Grid). I've been asked if it is possible for them to open the schedules in a new tab rather than opening it up in the same tab/window,…
-
Medical Publication Tracking- what is best template to start?
Hello, Any insight to the best Template or Template Sets to use to initiate: --basic tracking for medical publications (ie, manuscript development; congress abstracts & posters & presentations) --with "at risk" elements; or Red, Yellow, Green notifications Thanks!
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
