-
Annual Calendar Template by Day multi activities
Hi, the default set up for the Annual Calendar template seems to only anticipate one activity per day. How can I input multiple Activities per date without adding a new row and duplicating the day of the week and date?
-
Linking Rows in a Master Sheet to a Separate Sheet
I have a master work plan with various departments. Each department is a parent row and the department's tasks are child rows that roll up. I would like to take a department's entire section from this master sheet and link each task/row to a separate sheet that is dedicated to only that department. My goal is if a change…
-
How to return more than one value with multiple serach values with vlookup
Hi, I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C. My Question here is when I need to show multiple values based on multiple IDs. Example: If ID1=Result1 ID2=Result2 and ID3=Result3 and in ID column I write 1 2 or something like this and i want to…
-
Print table into template
I'm looking for a way where I can export a table from Smartsheet into a pre-set titleblock. If there's a way where I can print directly from Smartsheet and have the titleblock set up so it prints with the table, instead of just the logo and title that it's currently offered in the printing window.
-
Custom colours in grids
Hello. I love that custom colours can be selected by choosing the hex code or RGB values. This is especially great for the dashboard views with the graphs, titles, etc. One problem though is that we do not have the same option in grids. There the standard colours are the only options. Is it possible to add this to grids,…
-
What formulas help join people, teams, AND roles (person may have >1 team and >1 role)?
Stephen Covey says begin with the end in mind. I want to create views of people by scrum team and role as well as by role and scrum team (end result mock-up pictures below). It would be easy if EACH PERSON was only on 1 TEAM and only had 1 ROLE, however, there are other scenarios such as: * 1 person on 2 or more TEAMS as 1…
-
Why won't my COUNTIF formula not count anything from source sheet?
Hi all, I currently have a system for three spreadsheets: 1) Masterlist for open/closed actions that feeds a 2) Open Actions sheet, and a 3) Closed Actions sheet. The formulas for the first two sheets work perfectly, however, when it comes to the third sheet (Closed Actions), my COUNTIFS formula will not count anything on…
-
Automation - Sheet Update based on Criteria
Hello again Like a typical N00B I'm having wonderful ideas with almost no knowledge of the product (go easy, I'm just rolling into my 5th hour in 2 days of using it) I wanted to know if anyone has any experience or thoughts on how best to approach this scenario as I've found some challenges with my current workflow…
-
Workflow - recognising email domain as part of "assigned to" column
Hi all, I have two columns: Assigned to - this is set as the "contact list" property and linked to the address book so you can put an email address e.g. "firtstname.lastname@smartsheets.com". However in the field it would show up as "firstname lastname" without the domain at the end Company - dropdown box with 2 company…
-
database
Hello, Smartsheet team! I work for a medical equipment sales company which is intereted in create a database of all our client’s equipment. We want to sort all this information out in order to eliminate paperwork. We need to apply different filters which allow us to manage the record of all this equipment. Currently, if we…