I'm trying to write an IF/AND formula that references a different sheet to return a single row value. I think where I'm running into a problem is that I need the formula to evaluate three entire columns of data to see if the criteria are met, then return a row level value if all criteria are met on that single row. New data will be entered into this sheet regularly at scheduled intervals so the format of the referenced sheet needs to stay as is.

This is the formula I'm trying to write to evaluate the columns in the picture below.

=IF(AND({Rock Bin Date Column} = TODAY() - 1, {Rock Bin Time} = Time@row, {Rock Bin} = [Rock Bin #1]1), {Level}, 0)

The end result I'm trying to get from this formula would be 82, given the picture above.

Any help is greatly appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!