Autofill Lookup Fields

[Megan_Pratt]

I have venue table, with venues and associated travel times (in Number format). Another table has programs, with start date/time (in Date format). The program table links to the venue table, and there is a Lookup field with travel times. I would like to create a new field, "departure time", which is the start time minus the departure time. When I use the following formula:

DATEADD({Start Date},-{Travel time},"hour")

I get an error. To check the formula, I created a new field that is Number field, where I copied the numbers in the Lookup field. The formula then worked.

I am wondering if I can convert the lookup field directly into being a number so that the formula will work.

Thanks.

[TheTimeSavingCo]

Hmm, I hit the same issue you did, then I converted my formula to this:

DATEADD(
  Date, 
  {Number (from Table 2)} + 0, 
  'days'
)

Which seemed to fix it:

I have no idea what's happening heh but hey worth a shot to see whether it fixes it on your side!

Link to base

---
I also then tried removing the +0, and it didn't error out anymore, but it also didn't add the number?  I'm baffled