-
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…
-
If/Or Question
I would like RYGB column to; default ='Green' if today>[Proposed Start Date] = 'Red' if today => ([Proposed Start Date]-7) = 'Yellow' if [Actual Start] is not blank = 'Green' I am able to default to 'Green'. I have formula for 'Red'. I'm stuck when I try to add to my formula. The below is returning 'unparseable'. I've…
-
My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?
Hi, I am using this formula in a supporting sheet to calculate readiness for a task, but I keep getting zeros no matter what... =COUNTIF({Cross-site IHA Yes}, 1 / COUNTIF({Cross-Site IHA Ask 1}, 1)) Essentially this is saying, count all the "checked" boxes in column 1 and divide them by the number of boxes "checked" in…