-
Reporting from two completely different sheets
I have inheritied two sheets that have the same primary column (project name) but the rest of the columns are completely different. Is it possible to combine parts of these into a summary report? I want the report to have one row for each project listed in the primary column. In my current attempt the projects show twice…
-
Report Builder, Using Include and Exclude on Same Column?
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…
-
Using "@row" reference with ";" as the separator
Hi the community! I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";" When I use the "@row" reference in a formula, then extend this formula and come back to it, the formula separator becomes ",". So if I modify the formula without…
-
Calendar Legends or Headings
Is it possible to add a Heading or Legend to a Calendar?
-
Linking Data
I need help linking data from one sheet to another. I need the data to update real time, so that should a salesman update a projects, or ad another project in that satisfies certain requirements, the data automatically updates in real time on the linked page for my operations team. Reports will not work for this.Reports…
-
Formating
I want to center the column titles and color them. I like to remove the grid lines from it as well.
-
Rollup child rows for a particular parent row from multiple sheets
Hi, I have many Country sheets (Singapore, Japan etc.,). In each country sheet, there are multiple sectors (Media, Financial Services, Technology etc.,). These sectors as setup as parent rows and there will be child rows for each of these sectors. The child rows are not fixed in number but the parent rows are. I would like…
-
Reports consistency : include new sheets automatically
Hi I plan to have regular sheets created in a workspace(same structure) over the year. I want to use a report to consolidate all of these sheets in one place.I've put my sheets so far in a dedicated folder in this workspace. In the report builder, i pointed to this folder so i was hoping that any new sheet in this folder…
-
Report builder
Can i supply an input parm to run the report against a column and just extract the row/s that match the value in my input parm?
-
Best way to report a top of funnel of requests metric
Hello, We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you…
