How do I add a formula field to a dynamic filter

Hi Shontay,

Unfortunately formula fields cannot be used as dynamic filters currently.  You can read more about this from our Help topic here:

http://www.quickbase.com/user-assistance/#dynamic_filters.html


Good news however!  Our Engineers are working on deploying this functionality during one of our upcoming releases. Be sure to keep an eye out for our release notes!

http://quickbase.intuit.com/quickbase-blog


Brendan

Thanks

You can filer the report and then go into Grid Edit mode,  but you cannot filter while in Grid Edit mode.

Is this feature coming any time soon?

That feature came a couple of years ago. But it will not work for numeric fields. 

But if you know that the different numeric values will be limited, then you can make a formula text field to be the text equivalent of the number and then it will be eligible as a DF.

I'm having an issue where I'm trying to use a formula text field, which the logic is based on a checkbox being checked or not... and for some reason the formula field isn't able to be added to the dynamic fields.

Any idea why this would be the case?

np, just edit the field properties and make it "Searchable"

"Include this field when searching/filtering this table