Help

Use lookup field as a number

86 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Megan_Pratt
4 - Data Explorer
4 - Data Explorer

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.
1 Reply 1
TheTimeSavingCo
15 - Saturn
15 - Saturn

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:

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