Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help!  I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water


I would like to build a formula so that status will change to "Red" and type will change to "Renew"  when date is past "Expire Date".  I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date


I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors.  Is there a way to specify a range from row 25 to infinity?  I'd like additional rows to automatically be included in my summary