-
Dashboard - error pulling data
I have created a Dashboard. I am trying to pull the report data in as I have always done. I keep getting an error message. I re-created the reports and initially it will work. As soon as I hit "save" I start getting error messages. Help?
-
Center and middle justify summary fields in a report
I have created a summary field in my Smartsheet that is a formula: Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY()) Works just great! Returns a number that I would expect. The challenge is that when I create a row summary report that references the field Overdue…
-
Ability to Publish reports and sheets in Calender View for moblie users
Recently tried to publish (HTML link) a report to share with my team and ideally we'd like to view this in CAlender view. However the calender view is unavialble for mobile users who click through the HTML link. I would like to see the feature added on. As the gird view is not very the ideal display view, especially for…
-
Dynamic Reports and Control Center Programs
I am having an issue with our Dynamic Reports. We now have 2 separate Control Center programs that both look at the same Dynamic Report to list all of our high severity risks and issues for our projects. We are actually transitioning from one program to another. All of the projects provisioned from the old program were…
-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Combining Reports into one Report and Printing
if someone on team wants to get a report that has ways of looking at the same sheet, rather then creating multiple reports that, has smartsheet created a way to consolidate reports into one when sending it out to the team member rather then multiple? Also, has smartsheet found a way to print a report that looks exactly…
-
Why is the "Assigned To" field not an option to group by within my report?
Hello! I created a report with several columns, however, it does not allow me to group by using the assigned to column (setup as a contact list) . Does anyone know why this is happening?
-
Current User Filter showing blank report
I am trying to use the current user filter for a report I setup. The filter is based on the Project Manager Contact List Column and the report should show records when the Project Manager column is = Current User. It works for me but no one else. The people have editor rights to the underlying sheet and to the report…
-
Is there any way to enter a Formula into a Report Cell?
I have a sheet that has some weekly inputs. I've created a simplified Report View to only pull in the applicable columns from the most recent weeks/rows of data for the SME to populate. Recently, we had some data in our source information get split into two parts that our Smartsheet still only needs to report on as a…
-
What is the best way to update data between two sheets w/o having to do it manually?
I have a Project Tracking Sheet for all of my team's projects. One of our repeat projects is rollout of the inventory module in our company's primary software. Since we are a shared services group owned by a PE firm, the processes around this implementation are always the same, we just have to track each separately since…
