-
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…
-
Smartsheet Report builder not printing exactly the same view in the Report
Hi, Anyone had tried to print the Report with Summaries, filter and group "ON" and did not print the way it should be? Everytime, I export it in pdf file or print it, it is not showing how it was summarize and group like in the Report view itself. Anyone know how to print it correctly?
-
Effort Driven Tasks
This has been batted around for almost 5 years with SmartSheet promising that it will be upcoming. But I require Effort Driven Task. The Duration needs to adjust based on the % Allocation. This is essential. Please divulge why this has not yet been implemented and where it is on SmartSheet's roadmap for priorities…
-
Can I utilize a dropdown to save me from having to manually edit my filter to see each client
I have 3 Smartsheets that are currently feeding a report (see attached screenshot). (I'm having to go the Report route rather than using a Dashboard because Dashboard don't currently allow for bi-directional editing). On each report, I am wanting to filter down my information so I see/access just one client's data at a…
-
Correcting WeekOf and Avg Formulas
Hi all! I am trying to do 2 operations on some columns I have in a sheet. I have written (with your help ofc!) 2 formulas to fit my needs, these are a week of, and a avg formula. To be more specific, I have a sheet that has tasks on it. Assigned to these tasks are days it took to complete them, as well as the day of…