-
Calculate days between two dates w/o weekends
Hello all, I need to calculate the number of days between two dates (neither of which will be today), without including weekends. Does anyone know how to do this? Examples are listed below EX: 09/09/2019 - 09/08/2019 = 1 EX: 09/16/2019 - 09/13/2019 = 1 Any help would be much appreciated! Many kind thanks!
-
IF Statement - If two columns match any two columns on the page, flag it
Right now I have =IF(COUNTIF([Part Number]:[Part Number], [Part Number]1) > 1, 1) If the part number in row matches up with another row, it lights up a flag. I want to be able to add two checkpoints... If a "part number" and "ware" in one row matches up to another "part number" and "ware" on a different row, light up the…
-
Combining 2 Formulas
Hi, I have a column that is calculating today minus a date that is in another column. I have another column that is taking the days and converting it to weeks. Then i have another column that is taking the weeks and rounding down to 1 decimal point. Is there a way to combine the column converting to weeks and the column…
-
Help with Vlookup + date
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be…
-
Count Rows that are Open and Closed based with another condition
Hello, I tried to do a search here, but could not find what I was looking for. I have a sheet with each row being opened and closed with a date range. I would like to count the rows that have an open date but no closed date, and also count rows that have the closed date populated with any date. I also need to add a…
-
count open days
I need to count how many days have passed since an answer appeared I have the date column I have been reading on using the WORKDAY formula But I get the wrong argument = WORKDAY ([DATE] 11.5 How can I do to count the days? they work 5 days a week regards
-
At Risk formula help
Hello, I need help with creating a 'At Risk flag' when End Date is reached and Status is not complete. I have tried multiple combinations, can someone please review and help me correct this formula I am entering on Row4, End Date and Status are columns and Complete is a drop down under the status column. =IF(AND[End Date]4…
-
Identifying Duplicates within a column
Does anyone know how i can do this? it seems that SmartSheet does not have the ability to do this as in Excel.
-
Nested Crtiteria
Hi, I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria. =COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary…
-
Status for At Risk tasks due in 7 days
I have 4 status categories for my project with respective RYGB balls: * Complete (blue) * At Risk (red) * Requires Attention (yellow) * On Track (green) My current formula in the Health column automatically changes the RYGB balls when the status is changed manually: =IF(Status2 = "On Track", "Green", IF(Status2 =…