-
If cell matches cell in another sheet, return value from a column in that other sheet
Im working on a formula that will compare my Client ID column from my current sheet current row, to my Client ID column on my second sheet (called Production Log). When the client ID matches, I want the check date column from my second sheet to be returned. This is my formula. It is giving me an unparseable error.…
-
COUNTIFS formula for tasks due between 8 and 14 days in future
I'm trying to write a formula to count the number of tasks due between 8 and 14 days in the future. I started with a formula that is working for the number of tasks due in 7 days: =COUNTIFS({Schedule - % Complete}, <1, {Schedule - End Date}, <=TODAY(+7)) I could repeat the formula, replacing the +7 with +14, but I don't…
-
Nested Index/Match
Hello, I am currently trying to pull data into a primary sheet from several ancillary sheets. I thought about taking the data from the ancillary sheets, 8 of them, and putting them into one sheet but there are simply too may opportunities to mess the data up. I also hoped I could create a report that pulled in the…
-
How can I sum amounts only once from duplicate texts?
I'm trying to figure out a way to sum the amount column using only distinct clients and amounts that are tied to duplicates once. for the sake of the example let's say this is my data, the actual file has thousands of rows: in this instance, I want to create a formula that will sum 200 (for FIFA) + 100 (for Mcdonald’s) +…
-
Formula challenge
I want to remove the subjectivity in reporting on project domains. The aim is to use a formula to determine the 'summary rating' of a domain eg risk. This will be based on the content of the risk log (sheet). Community help is requested on the formula. The table below maps the thinking to develop the formula. I think it…
-
IF(AND formula
Hello Trying to combine two IF(AND..... formulas in one statement, not getting the correct output. Below is the statement I am using: =IF([Network Type]@row <> "", IF(AND(Irisview@row = "Y", xPT@row = "Y", [Sev1 / DI]@row = "Y", Brocade@row = "Y", ULM@row = "Y"), "Ready", "Not Started"), IF(AND(Irisview@row = "P", xPT@row…
-
Asset Availability Formula
I am trying to create a formula which allows me to input 2 sets of dates (a check-out date and a due date) which will then present me with the availability of the total assets between those dates. Does anyone have a formula that calculates availability based of existing availability/unavailability? I hope this makes sense.…
-
Using Formulae within Smartsheet Reports
Hi all, I am working on a project to aggregate data on a pan-European level with different Smartsheet files, a file per country. I bring all these different country Smartsheet files together using the Smartsheet report functionality. Some of the country data is in local currency and/or in square feet. I would like to have…
-
Budget calculation by specific association
This is probably very simple to most. :) I'm building a dashboard, and want to track expenses by individual association. I've taken the online tutorial, but just can't make it work. Any support is appreciated.
-
Formula to avoid the count of duplicate text entries
Hello, In one of my sheets, I have the formula to count the number of partners (existing and new). But I need to avoid the count of multiple entries for the partner names. See the image below: As you may notice the Partner - "GTA" was selected in two different rows and therefore it is counted twice in the # Partners…
