To get helpful responses
I am looking to resolve this issue if anyone have any idea about it, help me with it.
Include screenshots of
These are the only formulas i am seeing here.
I am looking to resolve this issue if anyone have any idea about it, help me with it.
I think this may be an issue from the Notion formula itself - the formula output is of unknown type (i.e., Notion can’t predict exactly the data type of the formula value). It could be helpful if you share your Notion database and formula setup (if you can share a public duplicable URL it would be great) and what you intend the formula to output
Hi Simo,
here is the public link for that database
link:- Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.
Thank you - I see that the formula result is of “unknown” type in Notion indeed. The formula is incredibly long so I haven’t analyzed it fully, but it seems that it uses several nested if statements, whose result is sometimes a date, sometimes a text, sometimes a boolean.
In its current state, you can’t use it in Make filters because of the unknown data type - if you want to implement a quick fix and have the formula result be of type “string” (which matches your selection in the screenshots attached to your post), you can add “.format()” to the end of the formula (screenshot 2). This should resolve the error messages in Make, although it’s a “quick fix” because it doesn’t address the data type “issue” in the formula itself.
Thanks a lot Simo, It worked