-
How to Setup COUNT/COUNTIFS formulas
I manage the educational benefits at my job and am trying to find totals of how many dependents, drivers, and office employees participate in the benefit. This is how I've been setting up my formulas. Yet when we cross reference with Excel the total number is off. =COUNT(DISTINCT(COLLECT([Employee ID/Driver Code]:[Employee…
-
Formula help
=IF([WD Schematic End]@row = "n/a", 0, IF([WD Schematic End]@row > [STR Schematic End]@row, 1, 0)) Above formula meant to trigger a red flag if the WD & STR Schematic End dates do not match. The formula I wrote is pulling back 'invalid' ... I am missing something and cannot figure out what!
-
Formula help: Counting user experience by date
Hi there, I am trying to create a formula to count by user experience (e.g., Positive, negative, Neutral, N/A) for each month. For example count if a response is in September and it is positive. I am referencing a different sheet and I have tried a few different formulas but I keep getting errors. I am assuming I need to…
-
Merged: Find and Replace in Formulas Please!!
This discussion has been merged.
-
Nested IF Formula
I would like the IF statement to return a specified value if based upon date ranges. For example, if a date falls within a range: 09/01/23 - 11/30/23 should return the value "Q1" 12/01/23 - 02/29/24 should return the value "Q2" 03/01/24 - 05/31/24 should return the value "Q3" 06/01/24 - 08/31/24 should return the value…
-
Using multiple IF(AND) statements in a formula
Hello, I am trying to create a column formula that will update Schedule health to a red, yellow, green, or blue circle using multiple IF and IF(AND) statements, but I continuously get the error message "#INCORRECT ARGUMENT SET" Here is my formula: =IF(IF(AND([End Date]@row - [Today's Date]@row <= 0, Status@row = "In…
-
JOINARRAY() function Idea
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed. =JOINARRAY(", ", A:A, " ", B:B) results in: x 1, y 2, z 3 blank values are ignored, hence the over-ride for the end of the item delimiter
-
If there is no info in the second date column leave the formula cell empty or say "incomplete"
I can either get the calculation to work or I can get it to say Incomplete when the second date is empty. How do I get it to do both?
-
Dynamic column reference
I have a smartsheet setup to act as a daily tracker based on working day with statuses of the activity getting updated using a formula. The formula I am using currently is: IF(AND((ISBLANK([WD13]@row)), NOT(OR(SubStatus@row = "Completed", SubStatus@row = "Not scheduled to start yet"))), "Daily update pending",…
-
SUMIFS with 3 criteria
Why is this function not working? =SUMIFS({Mai'23 Datenbank}; {Gruppe Datenbank}; Gruppe@row; {Ressourcentyp Datenbank}; [Ressourcen Typ \[FTE\]]@row); {Priorität Datenbank}; Priorität With only 2 criteria it works fine but when I add the third criteria smarthsheet will show #UNPEARSEAPLE I want to SUM FTE (Mai`23…
