I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to c…
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin …
I am looking to share only select results of a Form using a Report, but, in order to do so, it appears that I would need to provide access to the initial Form results. Is there a way to avoid doing th…
1 Can I do conditional formating using more than one criteria (different Columns) We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the …
I have a report that I need to pull units from yesterday. When I set the date threshold as 1 day in the past it pulls units that are from today and yesterday. How do I set the date to only pull from y…
Hello community, I need your help on this report. The solution is probably very easy, I just cannot get my head around it. I have a project plan with one column "Flag" (lines can be flagged with the l…
Is there a way to select/display just one row's information from multiple sheets into one report? Meaning if I am using the same template across 25 sheets and want just the one parent row from each of…
Hi, This has probably been asked numerous times but I just can't find the answer but I can't believe it isn't possible. I am making a simple equipment inventory with servicing data within it. The serv…
I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Form…