Hi team, I get the below error when trying to create a new column from a lookup in another table: "Failed to parse formula with error: {"offset":14,"token":{"type":"RAW_IDENT","value":"in","text":"in","offset":66,"lineBreaks":0,"line":1,"col":67}}" It's a date, and I've tried formatting in different ways but still get the error - which is weird because I can pull other dates in the same lookup column without issue. Here's the table: https://app.clay.com/workspaces/223473/workbooks/wb_0sx0p6e5Fy2d2hvTaU2/tables/t_0sxfk0lX8nd62GcY5HG/views/gv_0sxfk0mHiAdjkNiEbgR I'm using the green highlighted "Lookup Site" column to try and extract the "Final - Date Machine Declared "in service" field.
This error typically occurs due to syntax issues in your formula. The error message suggests there might be a problem with the "in" token in your formula. Try these steps to fix it: 1. Refresh your browser using Cmd/Ctrl + Shift + R 2. Make sure you're using the correct syntax when referencing the lookup column 3. When creating your formula column, use the AI Formula Generator to help with proper syntax Could you share your exact formula so I can help troubleshoot the specific syntax issue?
Hey there thanks for reaching out, fixed the issue for you, the problem was the formula being used was not properly formatted here.
