kuovonne: You have discovered that lookup fields are one of the most confusing fields to use in formulas. It sounds like you have found a workaround. However, for future reference, I recommend using a rollup field instead of a lookup field. th...

fixed. It is you airtable, it is not me!!! I have a value that was put in as a number in table 1. I lookup a field in table 2 that corresponds to a value in table 1 and then attempt to add to a date, it does not work. I figure it is turned into a ...

FYI, formatting has been triple checked, not an issue. I also tried the dateadd function from the same date with a hard coded number and it works fine. Something in the lookup process turns the lookup value not into a number, and the value() functio...

I am having an identical issue. My Table 1 has a number ‘X’, formatted as an integer (although I tried decimal as well, no difference). Table 2 looks up the value of X. Another field in Table 2 takes X and does a date add: DATEADD({date}, X, ‘day’...