-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
-
Reporting Issue - Not pulling data from a Baseline Schedule
Hi - I have been using reports for a few months and just recently created a few Baseline reports to monitor Project Schedule changes. I have followed the SMARTSHEET method of creating the baseline and creating the report. My issue is that the report will not draw from the baseline schedule. I tried just by itself and no…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
Report not pulling all sheet rows w/ linked cells
My Sheet contains all linked cells. There are 4 rows. I create a report to pull everything from the sheet with no conditions (Who? What? When?) but I only get back 3 rows. I have tried adding additional rows to the sheet but it still only returns 3 rows Help?
-
Report not reading contact list field from source sheet
Greetings Smartsheet Community! I'm having an issue building some reports. In my source sheet, "Art Requests", I have a contact list column called "Designer". This is where the project request (submitted via Form) will be assigned. I have defined the options in the dropdown. When I go to build a report to make one of the…
-
Publish Reports as Read only HTML (same as sheets)
Hi I'm currently sharing some progress tracking sheets by publishing them via "livesheets for Powerpoint" and then running the Powerpoint through a large display screen in a number of our offices. This is allowing us to keep a wider group of staff informed of progress. In an ideal world I would have looked at using SIGHTS…
-
Build Report for Group of Users
We have a number of User Groups.. some users overlap groups, as many of us wear a few hats. I'd like to build reports that run through the "ZZZ Workgroup" and look for lines that are assigned to anyone in "Group AAA." Perhaps also reports that pertain to "Group BBB" and "Group CCC" Yes, I could select each person in the…
-
Report - Share Access
I would like to be able to run a report on the Share Access on all Smartsheets that I own & as well as on Smartsheets for which I am an admin. (e.g. SS name, user name, share permission) I understand this is possible but only by requesting a 'Sheet Access Report' from the System Administrator…
-
Charting cell values over time
Hello, We are using the smartsheet as an interactive issue resolution tool in a workspace environment where each project has its own smartsheet. We have the dashboard set up which pulls key data points we are aggregating within each smartsheet (ie number of open issues, how many are high priority, medium priority low…
-
Office 365 (Form) Web Content integration
I am trying to integration a office 365 forum web content link into one of my dash boards. But I get an htttps error but the shared link does us https. Smartsheets says it has Office 365 integration but is it only for certain tools sets within Office.