-
Report will not allow me to choose one of my sheets
I'm trying to create a report for one of my sheets, but for some reason I cant select it! There is another sheet that has identical columns/permissions as the one that I want to use that I can select, but for some reason not the one I want. What could i be doing wrong?
-
How to Implement Time Reporting and Assignment in SmartSheet?
Hi Everyone, I hope you are doing well. I have a question. I have maintained 2 sheets, one for Project Assignment to Resources and one for Resources Time Reporting. In first sheet (Project Assignment), I assigned Projects to Resources on Weekly basis. In the second sheet (Time Reporting for Resources), I have maintained…
-
Sheets in Reports
Hi there, I have a question and an answer is greatly appreciated! I have a report that pulls data from standard sheets across all workspaces we have. I need that same information to be pulled from every newly created workspace in the portfolio without me having to add those sheets manually. Is there a way to automate that…
-
Edit locked columns via WorkApp
Hello, I have a sheet that is shared to a couple of groups of people. One group has Admin access to the sheet so they can edit locked columns, the other does not (only want them editing certain columns). I would like to have all users access the sheet via a report on a WorkApp. My question is, will the admin access…
-
Alerting when a new line is added to a report
Hi folks! We have our product roadmap that is being accumulated from 200+ different smartsheet for the different product development teams. My job is to build a technical support training curriculum for the new features that are being deployed so we can better serve our customers. I created a report that accumulated all…
-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…
-
Formula to find the average word used in a column
Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
-
Compile a list of unique values
I've been playing around with this all day. I'm trying to figure a way to compile a list all the unique values in a given column (in this case, business entities/customers). I'm matching that against an "Inactive" checkbox and trying to end with a list of all customers with currently active projects. Ideally in a report so…
-
Dependency with Teamworks
Hello! I'm new to Smartsheet and trying my best to learn so please be patient with me. We are a small company and are starting to properly organize our team using Smartsheet and TeamWork but we're running into a wall. My boss found out that if you link TeamWork together they both share co-dependence meaning that if you…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…