Newbie Question: Want to Count "Product Name" but only if its date is in the future
I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped.
I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting to highlight it if there is more than one time the product is mentioned.
=COUNTIFS([Product Name]:[Product Name], [Product Name]@row)
"If Helper is greater than one and Product Name is not blank than apply this format to the entire row"
I would like to have a set of formulas/ conditional formatting that highlights product names ONLY if they are in the future more than once. But, my current formula calculates all times the product name is mentioned in the sheet.
EX: If "Apples" is listed twice, for March 31st and April 8th, I would want that highlighted. I would NOT want it highlighted if there is "Oranges" listed January 8th and June 16th, because there is only one "Oranges" in the future.
Apologies if I am not making much sense! But I am very new to formulas and any advice would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!