-
COUNTIFS and DISTINCT
Hi there I'm struggling to get the syntax for a COUNTIFS(DISTINCT formula. I am creating a check sheet which counts only unique references against an SPV name. I have a list of the SPV names and I only want the check sheet to count unique references from the data input sheet with unique references and that match the…
-
Text to Traffic Light symbols
I am trying to turn text in a status column i have shuttled over using data shuttle from Excel into Smartsheet into a traffic light symbol. My column is Called Status, and the text in the column is green, yellow, red. I thought if i changed the column type smartsheet would identify this and convert to a traffic light…
-
How to Count how many times a cell is in a column
I am struggling with a formula how many times Delta appears in the Client Column. The formula I am using is: =COUNTIF((Client:Client), FIND("Delta", Client:Client, >0))
-
Can someone help me with a date formula?
I have a column that shows how many days have passed since a start date. I would like to add a column with an end date, and if there is an end date, have that count stop. So if the end date is blank, the count will keep going up. If the end date is entered, it will show how many days passed between the start date and the…
-
CountIf Day is between Start and Due Date
I'm stumped in this formula... I wish to perform a countif when a date is between two dates. I have a Start Date and a Due Date Column and in another sheet I have a list of days. and I want to count how many times the day June 07th is between Start Date and Due Date In the case below June 07th should be counted as 1, June…
-
How to display Days Elapsed only if Status is Open?
Like the title says, I'd like to only show the number of days elapsed when the status is on Open. I'm currently using this formula: =IFERROR(NETWORKDAYS([Report Date]@row, [Due Date]@row), "") Any tips would be highly appreciated!
-
SUMIFS the two columns meet the criteria for each column (USA)
Hi, I am working on this formula,... What am I doing wrong? criteria 1 is the words --"2022 Donations" and criteria 2 is data between two dates for quarterly sum of $. =SUMIFS([Paid $]:[Paid $], Codes:Codes, "2022 Donations", Date:Date, ">=01/01/2022, <=03/31/2022")
-
Need help writing a Nested IF, IF OR and IF AND Statements
I am trying to write the formula correctly, I have a couple different versions and neither are working. I can get the first 2 parts to work in this version, but the last part fails giving me INCORRECT ARGUMENT =IF(OR([Line of Business]@row = "Valuation", [Line of Business]@row = "Property Management"), "Final",…
-
How to I calculate percentage progress in sheet summary based on status?
How to I calculate percentage progress in sheet summary based on status?
-
IF formula doesn't work?
Hello, I am using an IF formula to generate numbers but it doesn't seem to work when i have numbers over 10,000 and it just spits the same number back out. See below: the formula I am use is: =IF([column 1]@row >= 6500, "6,500", [column 1]@row) so I'm trying to get it to say if column 1 is over 6,500 then only write 6,500…