-
counting row values with multiple criteria and excluding duplicates
Hello. I am new here. Appreciate if some one could help me. I would like to count only row values excluding duplicate but meeting multiple criteria. Below is the sample of my smartsheet. Is there an COUNTIF formula that will count unique values only once of Ref No column if Part Number and Order No is the same. Thanks!
-
Aging Formula?
Looking for a formula that would express the following logic: If item has been approved [Approval Date], Count # of days from Approval Date to TODAY. If item has been completed, [Completed Date], Count # of days from Approval Date to Completed Date. I've looked through the forums, but can't find something that appears…
-
Cursor Bug when Referencing other Sheets in a Formula
Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…
-
COUNTIF blank (Date column)
I'm trying to count rows that do not have a date value added in a date column. The right answer is 5, but when I use the following formula, I'm getting 177: =COUNTIF({Approval Date},"") I've also tried the following with the same results: =COUNTIF({Approval Date},ISBLANK(@cell)) Any clues?
-
Can anyone help with my "IF" formula?
Hi, I'm looking to create an "IF" formula for the 'Health' column circle boxes Blue = Status: Complete Green = Status: On Track Yellow = Status: Not Started Red = Status: On Hold and Status: Off Track This is my attempt of the formula but I am receiving an error messaging - can anyone help? =IF(Status3 = "Complete",…
-
Gestational age
Hi all, I'm sorry if this has been asked before, I can't seem to find anything on it. I'm looking to calculate gestational age- the age of a fetus in weeks and days using the due date for reference and a typical pregnancy being 40 weeks. I have it in Excel but I can't seem to get it to translate over. Any help is so…
-
CountIF - Boolean Expected
I'm trying to use two countifs formulas to determine if the "last contact" is within 30 days. However, I need to know if it is in the last 30 days based off of two parameters (either in last 30 days of EE contact OR Consultant contact). below is the formula I'm using and a copy of my sheet. Based on what I read on the…
-
If statements
I am trying to generate a 1, 2, or 3 depending on if certain cells have text in them. So far I have =IF([Invoice Number]@row = " ", "1" , "2"), IF([Paid Date]@row = "<>", "3" ,"2") What I need is if invoice number is empty a 1. if invoice number is full and paid date is empty a 2. if invoice number is full and paid date is…
-
Why Smartsheet is not supporting Days360 formula? I am not able to parse my data from excel to SS.
Why Smartsheet is not supporting Days360 formula? I am not able to parse my data from excel to SS.
-
Formulas for a range of dates in relation to today.
I am trying to rollup data to summarize how many projects have a completion date in the next 30, 60, and 90 days. Currently, I have them set up like this. =COUNTIFS({2021 Strategic Plan Initiatives Master Range 2}, <=TODAY(30)) =COUNTIFS({2021 Strategic Plan Initiatives Master Range 2}, <TODAY(60)) =COUNTIFS({2021…