-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
-
Importing contact information
Hello, I have a list of 450+ contacts with name, email, and two phone numbers. I know that I can mass import the names and emails, but the phone information does not come over. Is there a way I can do that? Thank you, Tayler
-
concatenating dates
I'm trying to concatenate a client code column (in a text format) with a long form date column (2018.04.27) so the concatenated column would appear like this — BHI2018.04.27. But, when the date appears in the concatenated column it shows up as BHI09/08/20. Is there a way to make the slashes go away, or have it appear in…
-
Template for routing for signatures?
Hi all, I'd like to create a template that can be used to route through our Root Cause Analysis Team for signatures. All plans need to get signatures from team members, patient safety managers and hospital leadership. Does anyone have an existing template that you could share that would serve this purpose? Thanks for any…
-
How many versions?
How many file versions will Smartsheet keep of each file? I'm part of a business plan.
-
Dashboard Chart to Match Current User Report
I've set up a current user report that accurately lists all project submissions for each user when viewing the dashboard. I'd like to include a corresponding pie chart to visually indicate the number of projects each user has per status (in progress, pending feedback, on hold, etc.); however, the current user filter either…
-
Sorting not working properly and I'm under a deadline 😳
For some reason when I try and sort columns in either my sheet or a report based on the sheet, the sort does not work properly. NOTE: there are no hierarchies in this sheet. It seems as if the Sort is not respecting the orders of magnitude. So 36 is somehow senior to 344, for example. At first I thought it was because the…
-
Sheet Summary Report by Month
Hi everyone, I've created a report that we generate every month by choosing to run the report between X and Y date. Simple enough. The report is generated from our master sheet. I have another sheet that calculates some statistics. I.e, number of staff, cost per trip, cost per trip type, etc. Our mastersheet can be…
-
Outlook Add-In
How come there is only a start date when you create a task from outlook? Due date is greyed out.
-
Formula for Contact List Column
I am trying to have two contact list column cells ("Assigned 1" & "Assigned 2") carry their information into another contact list cell ("Assigned To"). What formula would you use in my "Assigned To" (a contact list column)? Or does this need to be a manual task? Thank you for any assistance you can provide.