-
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…
-
Add more than one column data to chart (x,y scatter)
Hello, I am trying to generate a chart from a report that contains three columns. The first is the subject (label), the second the day (time to be plotted on the x axis) and the quantity (to be plotted on the y-axis). Since I am plotting from a report, I don't want to reformat the x data to columns as other posts have…
-
Renaming Column Name in Report instead of Source Sheet
1) Is it possible to change the Name of Column in Report instead of Source Sheet. 2) Auto Columns name is appearing in the Report instead of Column Name (Ex. Created by , Modified By, Created Date and Modified Date). Is there any way to change System Columns name in the Report. Thanks for your support. Best regards.