-
Countifs Past 90ds referencing another sheet
Hi, I am trying to make a dashboard that shows the top 10 pieces of equipment with the highest number of issues in the past 90d. I have my primary sheet that collects the data (Primary), and a reference sheet I am using to collect a count. I am just struggling to have it filter the last 90d. Showing #invalidoperation…
-
Reports Showing Blank Results for Current User Filter
I'm sure this is user error but I've been trying to figure it out on my own and coming up blank. I have a couple of reports I've created and want to show returns based on the current user who is viewing the report. I've asked different staff to test the view and they are both getting a blank screen. 😫 I'm not sure what I'm…
-
Need report that only shows fields that are NOT blank
Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column will vary widely but some will be blank, and I do not want to show the rows that are…
-
Allow Count Unique Values Only In Report Column Summary
In addition to being able to count and sum a column in a report, I'd like Smartsheet to be able to count UNIQUE values within a group. For example, I have a report shows me all tasks from multiple projects and groups by project manager. If I try to count the Project column to see how many projects each Project Manager has…
-
I need to generate a report
Hi All, Myself vinoth, Im working on a manufacturing company which has three departments, i have total four sheets which is Main sheet, Pre sheet, foundry sheet, post sheet, each sheet has his own data like section status and their plan date, target etc, totally around 10-15 columns remain same for all the four sheets, we…
-
How do I report cost changes?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…
-
Report grouping by date not working
I'm trying to group by end date on a project plan but the grouping is splitting out the same end date into multiple groups.
-
Please Help
I am trying to use this formula- =IF(CONTACTVALUE({Hardware}) = "Andrew Mattos", [Points Bucket]@row - 10, 0)- Basically I want it to search my TR Project sheet for the Hardware column and if it see's Andrew Mattos contact to subtract 10 points from my point bucket column in my data sheet. It keeps coming back Unparseable.
-
Locking Monthly Dashboard Reports
Hi there, I am trying to find a way to "lock" a dashboard so that the reports do not refresh on the dashboard for a month. If this isn't possible are there any suggestions on how to create a monthly report utilizing the dashboard? Thanks!
-
RAG Status
Hello! Newbie here :) I was wondering if someone could help with a formula I'm attempting to put together to calculate a RAG symbol status for individual tasks as well as the overall project plan. Individual Tasks: If status is complete = blue If status is in progress OR not started AND end date is today = yellow If status…
