-
Reports-Calendar View- Tasks from various sheets intermingled, how to fix?
Hello, I created a report to pull various training calendars into a master report. I have New Hire classes vs Cross Training classes color coded from Conditional Formatting. When I look at the Calendar View of the Report, notice how some of the blue colored tasks are falling under the green colored tasks. How can I keep…
-
Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible. I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet if…
-
Merged: Ability to format Reports
This discussion has been merged.
-
Showing the Parent Row in a Report
Hello Community, I have created a report where I am only showing if there is information to show, however my Parent Row (which in this case indicated which week the information comes from), isn't being shown. Any ideas on how I can have the Parent Row from the Source Sheet show up in my report?
-
Assign Tasks to people without they having to see everyone elses task
I have created one master sheet with ask entire list of task with assigned to column. I want to create either new sheets or reports what every person has their own task list and they cannot see other people's task. Is it possible. In their own report or sheet they should be able to comment and add details to the columns…
-
Control Center : Global Update : adding new reports to provision - should use same permission config
When new reports are added to blueprint and want to add new reports from Control Center to all provisioned projects, report permissions are manual update for each provisioned projects. It should carry the Control Center Permission Config which user should have what permission level so we don't have to manually update…
-
Import vs Copy and paste
Hello, I currently have a report that gets generated outside of smartsheets, we call this the BOAR report. I previously was copy/pasting the BOAR into a smartsheets grid but sometimes the BOAR is very large and cannot be copied. The reason I was not importing the BOAR is because I have multiple ss reports that are…
-
Publish Report Link as Read Only- HTML
Publish report links with as Read Only-HTML like you are able to publish sheets to have the ability to remove attachments and comments. Hiding Columms still allows users think the links to view that attachments, and incorporating the report into a widget takes too much time
-
Linked sheet data not refreshing
I’m unable to use a report as I need to pull data from two sheets that I don’t own and do a calculation .. because of this, I insert data from the whole column of the source sheet into mine as a link. Everything works great until new data is added. Most of the time it works .. but I’ve noticed some quirkiness when new rows…
-
Smartsheet report - filter criteria - task name
Hi all, I was trying to build a smart sheet report to consolidate 3 projects. However at the filter step I couldn't see any task option there whilst I do have tasks set up in every project. Did anyone have the same problem? Did I set up projects incorrectly? I'm grateful for any help and advice here. Thanks, Ringo