-
Best way to show KPI's across multiple projects and teams?
Hello all, I'm trying to determine the best way to capture multiple KPIs on a dashboard. Each cross-functional team has their own sheet where they manage projects. What is the best way to have them capture data metrics (the KPI's might be different per team- hours saved, increased NPS, $ Saved) that roll up to a dashboard?…
-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…
-
Maximum number of cross-sheet references per sheet
Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together. I am about 90% of the way through and just encountered the below. The way my sheet has been structured makes it impossible…
-
Image import from Excel/Sheets
When importing a spreadsheet from Excel or from Google Sheets, it would be SO helpful to have embedded/pasted images come into the new smartsheet as attached images. Use example: Users copy/paste screenshots into a Google Sheet being used as a bug tracker, because Google Sheets makes it very easy to do, but then they're…
-
Joining multiple COUNTIFS statements
Hi there. I'm trying to create a single formula that will count items in a column on sheet A if they fall between two dates and also count items on sheet B if they fall between two dates. The item name is the same in both sheets and the date ranges are the same in both sheets. The formula I have (which does not work) looks…
-
Struggling with formula that references status in another sheet
Hello Smartsheet friends! I have a sheet (called Test Receiver Sheet) where I want a box to be checked for each row if the client code for that row matches client code on the second sheet (called TEST Client Audit Form) AND the status is "Complete". This is the formula I have so far. Im getting an invalid reference error.…
-
Count Collect formula assistance needed
Hey all, I'm using a Count Collect formula I grabbed from the PMO template as a baseline. Here's the original formula: =COUNT(COLLECT({Task ID}, {Task Status}, "In Progress", {Task Health}, $Label@row)) Only thing I changed from the PMO is instead of "Project" I changed it to "Task". I'm trying to get similar metrics on…
-
Cells linking not working correctly.
Hello, we have a Template folder with a set of sheets which are all cell linked amongst each other, these have been working perfectly for 2+ years. When we get a new project in, we “Save as new” the template folder with the project number/name. In recent projects we have noticed cell links missing but just relinked the…
-
Linked Cell Not Working
Hello! We are linking cells from a project plan to a master sheet. Every other cell in the row linked just fine, except for the last one. It says that it is linked, but no information is being pulled into the cell. The cells in the project sheet are filled out and linked out to the master sheet: These are the corresponding…
-
Curiosity: Best practice use of symbols for health on projects
Hey all, I'm curious as to how others are utilizing the symbols for project health when tracking health task-by-task in a project. If you are using RYGB or RYGG, how are you indicating future state tasks? Gray or Blue is being used to indicate "Not Started" tasks or future state tasks Gray or Blue is being used to indicate…
