Robert S Fike
Robert S Fike ✭✭✭✭
edited 04/11/24 in Smartsheet Basics

My formula was working and then i tweaked it by adding an IF(AND statement to it. Is this possible and i have something wrong. Or will this not work in this senario.


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Robert S Fike,

    Trim it down a bit to:

    IF(AND([Neighborhood Lots]@row="Hampstead - LNH", [Block]@row ="U"), "6A",

    And then move it before the previous IF statement - this has the "Hampstead - LNH" Neighborhood Lot in there already (giving a "6B" result), which will be triggered as a positive before your AND statement if left as is.

    If I'm honest I'd probably be using a cross sheet reference and an INDEX(COLLECT) given the number of results! 😉

    Hope this helps, but if I've misunderstood anything or you've any further problems/questions then just ask!

  • Robert S Fike
    Robert S Fike ✭✭✭✭

    Thank you very much. I will look into the index(collect)