Best Of

Odd, it worked on this side when I tested it.

Per Formula error messages | Smartsheet Learning Center:

#UNPARSEABLE
Cause
The formula has a problem which prevents it from being parsed and interpreted. This can happen for many reasons, such as misspelling, incomplete operators, using the wrong case for a column name, or using single quotes instead of double quotes.

Resolution
Ensure that all column names are spelled correctly in cell references, operators are being used correctly, and any text strings in the formula are surrounded by double quotes (" ").

Looking at the below the actual structure looks okay. So, I'd recommend 2 things - first, modify your "Days Duration (Received to Listed)" column formula to include an iferror() statement to force anything non-numeric to be text (I like just "", that way it is empty visually - but any text will work) instead of an error message. Error messages in referenced columns tend to break things and error traps are a good practice in general. Second, double check all your column names and types. This formula would expect the following column names and types:

Days Duration (Received to Listed) - Text/Number

Date Received - Date

=avg(collect([Days Duration (Received to Listed)]:[Days Duration (Received to Listed)],[Date Received]:[Date Received],>=date(2025,1,1),[Date Received]:[Date Received],<=date(2025,1,31),[Days Duration (Received to Listed)]:[Days Duration (Received to Listed)],>0)

Excellent, glad I could help!

Hello @Almrie217

You're almost there! You're just missing some formula logic on your OR statement using "@cell".

Try this:

=COUNTIFS([PRODUCTION STAGE]:[PRODUCTION STAGE],OR(@cell="DELIVERED",@cell="PRODUCTION"),TYPE:TYPE,OR(@cell="Mug",@cell="Cup"))

If you'll be using a multi-select dropdown column, you need to utilize the HAS function.

=COUNTIFS([PRODUCTION STAGE]:[PRODUCTION STAGE],OR(@cell="DELIVERED",@cell="PRODUCTION"),TYPE:TYPE,OR(HAS(@cell,"Mug"),HAS(@cell,"Cup")))

Note that the HAS function checks if the cell has that value selected. So for example, you have 3 rows that has either "Mug", "Cup", or both "Mug" and "Cup" in a cell. It will not count as 2 values when a cell contains both Mug and Cup. I hope I makes sense.