-
Pivot sheet won't show what I see in Preview
Hi there, I created a pivot report that sorts items by month. I have 19 columns with two rows currently -- January and February. When I look at the sheet that I created with Pivot, it only shows that data that is not assigned to either January or February (BLANK). I can see what the data should look like when I click the…
-
best way to convert excel tracker to smartsheet
Hi all whats the best way to convert this tracker on smartsheet any ideas will be appreciated @Paul Newcome tagging as always for your advice please
-
Max and index match function
Hi all, i have a sheet where Trailers are logged in multiple time throughout the day and what they had in them such as a PO number or a load number in a separate sheet i want to type in the Trailer number and i want it to pull the recent entry date of the trailer and the Load number / po that came in that trailer. How can…
-
considering switching from CRM to Smartsheet. What's the best way to ensure a smooth transition
Do we have any standard templates related to CRM in Smartsheet? Appreciate insights and advice from those who have undergone similar transitions or have expertise in utilizing Smartsheet for CRM purposes. Specifically, I'm interested in: Strategies for migrating data from our current CRM system to Smartsheet. Best…
-
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
-
Multi-tier reporting in Control Center?
I am looking for a way to set up a report in my parent blueprint so that: Every time a new child project is provisioned, a specific sheet from that project is added to the report at the parent level. The parent report is a collection of that sheet in all child projects. Things I tried that didn't work: -Adding the child…
-
Customized Report
How do I create a customized report that, for example, uses just the values (no column names) from different sheets? Would it be considered a dashboard? Which feature do I begin with?
-
Customized Report
How do I create a customized report that, for example, uses just the values (no column names) from different sheets? Would it be considered a dashboard? Which feature do I begin with?
-
Data Mesh: Stop feeding Deleted Rows to Data Mesh sheet
I was told that once rows from a source sheet make their way to the Data Mesh sheet, there is no way to remove them. Even though the rows may no longer exist in the source sheet, you can't prevent them from showing up again in the Data Mesh sheet. My source sheet (report) is pulling from multiple projects so it's not…
-
Is there a way to weight a report based on a value?
We track tasks with smartsheets and we have an effort level column that is meant to help demonstrate (via a report) what workload across a department looks like. We want to be able to create a report that weights projects with a '1 effort level' smaller than a '4 effort level'. Any suggestions on how we could do this?