-
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…
-
Using decision symbols: Yes, No & Hold
Hi all, Understand that this has probably been answered before however I can't quite find the solution I need and have spent a little too long trying to get this sorted. I need to display Yes, No or Hold symbols with the following parameters: If [Status@row] is equal to "Submitted" or "In-Progress" and [Created@row] (date)…
-
Track minutes
Hello, Can I please just confirm the only way to track hours & minutes in a sheet is by paying for either the 10,000 feet or Bridge add on? Thanks, Charlotte
-
Formula with range that goes from a certain row to whatever the current bottom row is
My formula: =AVG(COLLECT(IIQ28:IIQ99, [SE Manager]28:[SE Manager]34, "John Lennon")) First, I cannot use the entire column. There is data in rows 1-27 that can not be applied to my average. I want the range to go all the way to the bottom of the sheet, because this sheet is regularly populated by a workflow from another…
