Reference to another Sheet Help Please

bryant_t_

Hello,

I am trying to create a metrics sheet in which it tells you the last time someone visited an area within the alst 30, 60, and 90 days based on a smartsheet form. However I keep getting an error sign.

This is the reference sheet. I only want to count the areas rounded.

Kerry St. Thomas

Without even drilling into the formula itself… it looks like the issue is the column type. The "Area(s) Rounded" allows you to choose multiple items on the dropdown. SO… if someone chooses "AB Receiving" on one row, that's a different thing to count than a cell with "AB Receiving" and "A Material Manag." in it. I haven't tested, but I think you'll want to use COUNTM instead in your formulas, possibly also using CONTAINS. More on the functions:

https://help.smartsheet.com/function/countm
https://help.smartsheet.com/function/contains

Good luck!