Use lookup field as a number

1469 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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.
1 Reply 1
18 - Pluto
18 - Pluto

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


  {Number (from Table 2)} + 0, 


Which seemed to fix it:

Screenshot 2023-05-27 at 3.39.14 PM.png
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