-
Need help with a formula that pulls from two sheets but gives #INVALID REF for one sheet
I had help a year ago to create a formula that uses a Project ID to pull data from two project sheets into a sheet that tracks project hours. I need to pull another column of data into that sheet, but my formula is only half working. It pulls from the active projects sheet but I'm getting #INVALID REF for data from the…
-
Progress with children rows
Hello all I have a tracking sheet for payments under several Purchase Orders (POs). Each PO can have different numbers of milestone payments—anywhere from one to ten or more—until the PO is completely paid. For each milestone, I need to mark it as 100% and then i need send invoice. The parent row should then show the…
-
Formule
In sheet A I have 400 lines where people have to check a box when they have received a document at the and i want to create a dashboard where we can see how many docs we rcvd back? We have three type of docs GDP TAPA FRIGO So i will have 3 colomn the result i want to see is in this case is: we had total 11 GDP docs but we…
-
Formula for Quarter & Year
I'm trying to pull the quarter & year from a column using a formula, but I keep getting "unparseable". I've searched through the community with no success using the answers found. I'm pulling data from my "Expected Close Date" column. Below is an example of a formula used. Any help is greatly appreciated.…
-
Trying to find the top three categories for Dashboard Metric
Hello, I have a list in my primary column with categories ([Primary Column]52:[Primary Column]93). The column to the right COUNT column has counts for the categories ([count]52:[count]93). I also have a ranking column next to that with the following formula in it from row 52-93 —> =RANKEQ([Count]@row, Count52:Count93, 0).…
-
how to combine multi formula conditions
Hi team, Trying to create a vehicle luggage capacity calculator for small and large cars, Please find below, Please find the below Formula: =IF(AND(Passengers@row <= 4, [25 Kg]@row <= 2, [15 Kg]@row <= 1, [7 Kg]@row <= 1), "Yes", "No") The formula above indicates the col [Result] is "Yes" in the ase of follows: The number…
-
Traffic light formula
Hi, I have a traffic light column in spreadsheet and I have a formula that triggers the colour based on a status column. I am just looking to add a step in that turns the traffic light red if it is not started or in progress and it is past the due date Formula so far =IF(Status210 = "Completed", "Green", IF(Status210 = "In…
-
How can I use COUNTIFS to get a count of projects and filter by date?
Hi, I had created a formula to give me a count of completed projects, but then my manager needed a count within a financial year. I can't get the formula to work, so I'm wondering if dates are not usable with that formula. If that's the case, what should I used instead? =COUNTIFS(([Project State]:[Project State],…
-
Dashboard count only if rows filled from a reference sheet
Hi. I am working on a dashboad to summarize some data from a reference sheet. I want to add a metrics widget that presents a sum of the number of rows on a reference sheet only if they are filled with a color completely. Details: I have a sheet with different project rows filled in green, indented under those are 'tasks'…
-
Can logic be added to a sheet?
My boss wants to create a sheet that includes 4 different profile forms. I'm curious if this is even possible. Basically, we have 4 different excel docs that are profile forms, we want to try to combine these forms on a grid in Smartsheets but we want the fields to auto populate depending on which profile form is selected.…