A formula that can read multiple cells and return a value

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

  1. reference a column and identify if a cell contains specific text
  2. once the cells with specific text have been identified, read if the next column contains a date
  3. 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
    Ipshita ✭✭✭✭✭✭

    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.



    Ipshita Mukherjee

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!