I need help trying to figure out a combination google sheets formula
If
Cell B5 contains "Rct"
And
today's date is 30 days after the date defined in cell C5
And
if Cell D5 and D6 both says "2 weeks ago" or "1 week ago" or contains the words "day" "hour" or "minute"
(not sure if possible but instead of the all those words could if be if the text in cell D5 and D6 are the color "green" and or "Yellow")
Then
Cell H5 will say "Y" if the above conditions are met or "N" if they aren't
Aucun commentaire:
Enregistrer un commentaire