Formula Field Displaying Duplicate Values

Baserow Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

I’m experiencing an issue with a formula field in Baserow that’s showing the same status twice. I’ve tried a few things but can’t figure out what’s causing it.

I have a formula that determines the status of an application based on several conditions (like the number of reviews completed and eligibility checks).
Instead of displaying the status once, the field repeats the same status twice (e.g., “Review Round 1 Completed Review Round 1 Completed”) as two separate records in the same field.
Here’s the formula I’m using:
if(isblank(field(‘review round 1 assigned’)),
“Application Submitted”,
if(field(‘Eligibility status’) = “Eligibility flagged :warning:”,
“Not Eligible”,
if(field(‘completed reviews’) >= 2,
“Review Round 1 Completed”,
“Reviews Assigned”
)
)
)

2

Hi @hafandhaf, welcome to the community!

Could you share some details and screenshots of how you have set this table up? What are the field types etc?

3

sure: the field types referenced in the formula are as follows:

  • review round 1 assigned is a linked field to a table it contains id strings linking a review to an application
  • Eligibility status is a formula field that contains a string signifying whether an applicant is eligible or not. It is calculated based on a logical and of multiple boolean fields
  • completed reviews is a count field, counting the amount of completed review forms for an application.