Does anyone know if it is possible to enable search (Ctrl+F / Cmd + F) for data generated by a formula?
I would like to fetch strings or codes generated in a formula field. Both for numerical formulas and for formulas that generate texts.
Help between Notion users
It's free & easy
Answers, votes & comments
Receive points, vote and give the solution
Does anyone know if it is possible to enable search (Ctrl+F / Cmd + F) for data generated by a formula?
I would like to fetch strings or codes generated in a formula field. Both for numerical formulas and for formulas that generate texts.
Hi,
Based on the official information, as of the current Notion version, there are some limitations to the type of content that can be searched with Quick Find in Notion.
Unfortunately, it appears that the results of formulas, which are computed values rather than static text, are not included in the search results. This means that you cannot directly search for data generated by a formula using the search function (Ctrl+F / Cmd + F) in Notion.
As a workaround, you might have to setup an API automation e.g. in MAKE to copy the results of the formula into a separate text field/block, which can then be searched. However, this would need to be updated each time the formula result changed. It is little bit cumbersome but the only workaround I am aware of.
Please note that this information is based on the latest available information I was able to get today and may have changed if Notion has released updates after this.