-
How do I get Summary Totals to appear on the pdf attachment?
I love the enhanced report features with the grouping and summary totals. But when I send this as an attachment, they disappear? Is there a way to print and save the report to an attachment so that it presents the designed view? Thanks for your help! Sheila
-
Update Master Sheet with multiple source sheets
I am trying to figure out a way to update my master sheet with information from multiple source sheets. For example, I have 10 departments. Each of those departments has their own employee information sheet. I need the master sheet to update not only as rows are added, but also update those rows as information in the…
-
Extracting time from a date field
Hi, I'm using Data Shuttle to import an Excel file that has a combined date/time. Smartsheet/Data Shuttle is recognizing the date, and bringing the field in as only the date. I've tried bringing it in to both date and text columns, same result. I've tried importing manually into Smartsheet (not using Data Shuttle) and same…
-
Why isn't the column info showing up on report?
In a report I created, the info in one of the columns (Fulfillment Due Date History) isn't transferring over from the original smartsheet the report is being derived from. The column in the original sheet does utilize a cross-sheet formula to populate the cells. Would that have anything to do with why the info isn't…
-
Add Optional Sheets to a project that's already provisioned in Smartsheet
Hi, I provisioned a project in control center. I left out some optional sheets. Now, a week later, I see that I want those optional sheets. Is there a way to add them to my project without having to provision an entire new project again? Thank you
-
number of different items, consider similar items once
Hello there, I am looking for a formula/function which can give me quantity of different items. something which gives me 3 (David, Sarah, Mark) if I apply it for Column 1, and gives me 2 (24, 43) if I apply it for Colum 2, on the below sheet: Note: I don't want to type David, or Sarah, etc, in the formulas because there…
-
Share Permissions on Reports
Question: Why in the article on Sharing Permission Levels does it say there is a commenter permission in reports but that option is not available when I go to share it? I thought I might need to give this permission at the sheet level first, I tried this but I still do not see the option to share the report as a commenter.…
-
Help with VLOOKUP
I am trying to pull data from one sheet into a summary sheet. Basically I am looking to pull if a given site met a target on a given day -- an admin is entering in the number of employees reporting for work on a day for each of 12 sites into a Smartsheet (called KU MR Attendance), and I need to see if they are meeting the…
-
Is there a way to protect an online form used to populate a SmartSheet?
I have a form that I use to gather data. I send the user the form, the user enters the data and clicks Complete and the data is then added as a new row in my SmartSheet. The questions in the form are very confidential and I don't want someone inadvertently gaining access to it. Is there a way to protect who can open that…
-
Is there a way to copy notifications into projects instead of manually setting them up individually?
If I have a workspace with over 200 projects that need to have the same notification automation, is there a way to have all 200 projects have the same notification without me going into each sheet and setting up the notification manually? I am looking for a way to save time and minimize human error. Thank you!
