A formula that can read multiple cells and return a value

SBenavi · 09/10/23

I would like to know if there is a formula that can

reference a column and identify if a cell contains specific text
once the cells with specific text have been identified, read if the next column contains a date
if both values are true then return a green dot and if the column 1 contains the text and column 2 does not contain the date then return a red dot.

Ipshita · 09/10/23

Hi @SBenavi Your formula in this case needs both an IF statement and CONTAINS statement and it should run something like -

=IF(CONTAINS("Jacket", [Clothing Item]:[Clothing Item]), IF(CONTAINS("09/08/2023", [Date]:[Date]), "Green", "Red"....

This is not the full function as there would be an additional IF statement for the blank date, but I want to let you try and let me know.

Cheers,

Ipshita

Answers