-
Report Column Names / Labels are not same as Smartsheet Column Names
Hi, I have noticed on reports created from the original smartsheet that the Primary Column Label and automatic numbered columns don't have the same smartsheet column name. When you pick the reporting you want to include it uses the original default titles as opposed to column titles used in the smartsheet (if you have…
-
Look up blank cell and add a value in another column on the same row
Can someone show me how to write a forumla that will look up if a cell in the column "Critical date" is populated enter 1 in column "CD2" on the same row. Essentially what I'm trying to do is run a report that summarises all my critical dates but I can't select that date column in my report. If there is a better way I'm…
-
Sharing Reports without sharing sheets
We want to share reports with customers so they can see schedules but do not want customers to be able to view other customers schedules on the primary sheet. In order to share a report we must also share the primary sheet. Is there a work around for this?
-
SUMIFS for multiple criteria
This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense". I have tried a few variations, but this is what I think should work? =SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019). I have tried quotations around…
-
Expand Project Row
Hello, I would like to know if you are able to expand a row into a dashboard view. For example, if one row shows a project I am working on, and I have included several notes.. is there a way I can blow it up into a quick view of all items of included in the row (notes, dates, etc.). I would like to show/send the project…
-
HELP! Summary Report to pull from different sheets based on multiple drop down selection
Hello! I am new to Smartsheets and am trying to build a Summary Report based on drop down selections and data from various sheets. I have a TON of data and too many cells so I've had to spread it out on a sheet per month. I have two drop down selections. One is to select the month and the other is to select a division…
-
Primary column not returning values in Report
I am creating a report using data from 5 different sheets. All 5 sheets use the same columns, including a primary column called Project Name. The column has data in on all 5 sheets, however this data is not showing in the report. Interestingly, when I print the report to pdf, I see the project name values.
-
Report to Pull data from Current Month
Hello - I use smart sheets to generate deposit logs for multiple clients. I give them access to their deposit logs via a dashboard. One of the reports they need is a deposit log for the current month. At the moment, I just update the report criteria to return the current months by adjusting the dates the report pulls, but…
-
Meeting agenda item reports
We're piloting the use of the template set including the past & future agenda item reports. The issue is the reports aren't pulling the correct data. I added a column to the meeting sheet that is the meeting date (function pulls it in date format from the parent row where the date is entered as text) so each child row is…
-
Resourcing is looking at SCC template gantts
Firstly, yes - I know the Control Center sheets are not "templates" but I would want resourcing to be able to filter out the workspace or at least the folder used to spin up SCC projects. Since I pre-load "assembly time" by assigning it to the genaric "Assembly" contact in ALL of the grouped gantt schedule options (of…