-
Project Settings from Report Glitch
Curious if anyone has issues using the "Project Settings" button (small gear icon in the top right under the share button). We thought we can adjust the project settings for the Gantt view on a report (or does it adjust the project settings for the whole sheet)? Either way, when we click the icon nothing happens. After the…
-
One Approval for Multiple Lines/Whole Sheet
Hi everyone, I have stuck with this problem for a while and seen many questions about how to consolidate the approval requests to be sent in one email. It seems like the only solution so far is to create a report with a approval column that has checkboxes for approve, deny, etc. My concern with this way is that, in case…
-
Turn off the "Get Started" message after a Report is built
Hello. Is there a way to turn off the "Build Your Report - Get Started" message after the report is built? This popup message continues to show up, even after I have built and saved a Report. Thank you!
-
Linking two sheets to create a 3rd master
Can you link to two sheets into a 3rd to create a master sheet? Trying to create a master sheet that totals cells from two different ones.
-
Calculating Schedule Health - RYBG
Hello, I am a beginner Smartsheet user and I have listed my set of requirement to track my schedule health task. The requirements are based off % Complete and % Time Elapsed. Requirements below: Tasks that show status of “Complete” - Blue Status in progress, where the % Complete is greater than or equal to Time elapsed. -…
-
Report Gantt Chart Project Settings
I am trying to change the Gantt Chart Timeline Display in a report. The report currently has the standard display as follows: I am trying to get it to look like how I have it in the original sheet below: Whenever I try and click on project settings either nothing happens or I get the error message below: I submitted a help…
-
Summary reporting with conditional formatting
Hello! I'm trying to build out a way to dynamically report on 58 state/territory sheets. Ideally, this report would have the total number of rows in the state sheet, plus the number of rows that meet two separate sets of conditions, with conditional formatting applied. I've tried doing this two ways: By using a sheet with…
-
Creating Report Workflow Automation that goes out on the 3rd Friday following a Monday
Basically, I can only use weeks where there is a Monday in that month before the 3rd Friday. So the native function of picking 3rd Friday will not work for this scenario. I have seen lots of help for Monday's but am not sure how to program this one. I need to send out a report reminder to owners the 3rd Friday following a…
-
Joining report on the Primary
If I have 2 sheets with the same Primary column, is there a way I can use reports to create a sheet that essentially joins the 2 other sheets using that primary column, and keep that unique in the output?
-
Reports
Hi SS Community, I have two sheets I'm trying to combine in a report. Both sheets have a column named "project name" as the primary column. I am wanting to filter the report based on one criteria from each sheet. But since the data is coming into the report as two separate rows I can only filter one or the other otherwise…