Error : Unable to find column 'separateID', did you mean 'separateID'? | It's an unusual experience.

[leinharte]

It's an unusual experience.

An error occurs when the following formula is entered in the column's App Formula.

IF(
        [separateID].[foreignCurrency?],
        [amount] *
               IFS(
                      [ceclassification ID] = "bigid51B0A476",
                      [term end exchange rate] - [average exchange rate],
                      NOT(IN([ceclass ID], LIST("bigid51B0A476"))),
                      [period-end exchange rate] - [spot exchange rate]
                       ),
               0)

The error message is:
Unable to find column 'separateID', did you mean 'separateID'?

BTW, if I change the part of  the formula "[ separateID].[foreignCurrency?]" by clicking "Data Explorer", in fact the formula content is the same, the error disappears.

Why does this happen?

P.s. FYI, if you copy and paste this formula into Google Docs and then copy and paste it into App Formula again, an error occurs.

Thank you

[1minManager]

So the format for IF() is IF(this is true, then do this, otherwise do this instead)  But in your formula you have [separateID].[foreignCurrency?] as the first part.  Is [foreignCurrency?] a Yes/No type column?

Personally I'd test this by having [separateID].[foreignCurrency?] in another virtual column to check.

Simon, 1minManager.com

[leinharte]

@1minManager  I appreciate your reply.

Yes, [foreignCurrency?]  is a Yes/No type column that locates in the separate table.

Let me show you the error case.

(1) The ceJournalFc table has the 해외사업장환산외환차이 column.

(2) And the expression of 해외사업환산외환차이 does not have an error at now.

(3) Copy and paste the expression to google docs.

(4) Copy and paste the expression from google docs to AppSheet.

(5) Then the error happens although the expression is same before.

(6) Delete the text "[separateID]".

(7) Click Insert of separateID.

(8) Then the error disappears.

Thanks for reading.

[leinharte · Accepted solution]

I made the mistake of including a space at the beginning of a table or column name.