-
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…
-
How can I write a COUNTIFs using a dropdown in one argument and not another?
I have 2 columns that I am trying to do a sheet summary on and can't figure best way to write. one column is a free text and the other column is a drop down list with several months. I need to get the counts of "Leaders" who select certain months (Oct, Nov, Dec, etc). Can this be done using CONTAINS ? =COUNTIFS($[Leader or…
-
I need help calculating the sum of one column based on a date in another column
OK, so I'm trying to calculate values (in one column) based on the Month (in another column). This is what I have tried: =SUMIF({1 - Sales Pipeline: Holly Greenhalgh Range 2}, MONTH(@cell) = MONTH(TODAY(), {Sheet - Sales Pipeline Range 3})) However, it returns 0. I'm referencing another sheet if that makes a difference.…
-
SUMIFS Formula
Hi I am trying to create a formula that will sum the No. of Minutes Taken to Complete Job based on the Job Type. This is what I'm using currently: However, its' bringing back zero when you can clearly see a CD Extraction Job Type in row two. I'm assuming it's because it is a drop down but, there will only ever be one…
-
Count Date + N/A
I have a columns "LAN M Actual Complete" and another column "2nd Touch Indicator" I need total Site complete: count if "LAN M Actual Complete" has a date and "N/A" in the "2nd Touch Indicator column" Dont' count if "LAN M Actual Complete" has a date or no date and "2nd Touch Indicator" is blank or something else besides…