Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Getting #ERROR! on formula, on sync'd base

Topic Labels: Sync
Solved
Jump to Solution
258 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey there I have a synced base that is pulling a “percentage” field from another base of mine.

I am running a formula field on the lookup field, however it is giving me an #ERROR! as a result.

I have tried using Value(), but nothing works…image

image

1 Solution

Accepted Solutions

Lookup fields most often return arrays, even when looking up a single value. In some cases, Airtable will automatically interpret the array as a single value, but it’s tough to predict when (even after doing a deep dive into the subject, which I outline in this base).

The VALUE() function expects a string, not an array. You could try converting the array to a string by concatenating it with an empty string, then taking the VALUE() of that:

VALUE({Recruiter(Candidate) commission%} & "") * {Otter net revenue}

See Solution in Thread

3 Replies 3

Lookup fields most often return arrays, even when looking up a single value. In some cases, Airtable will automatically interpret the array as a single value, but it’s tough to predict when (even after doing a deep dive into the subject, which I outline in this base).

The VALUE() function expects a string, not an array. You could try converting the array to a string by concatenating it with an empty string, then taking the VALUE() of that:

VALUE({Recruiter(Candidate) commission%} & "") * {Otter net revenue}

You are a legend!

Actually @Justin_Barrett what is really weird is I looked back this morning and the same column that showed #ERROR! last night is not accurate displaying the data.

Maybe this is due to some delay or lag in the data updating between bases… blows my mind.

Could you elaborate on that?

There is a delay, though the documentation says that synced tables update approximately every five minutes. My gut says that you should have seen an update (if there was one to sync) somewhere in your work last night. Do you have any automated processes that run overnight and alter the data?