Help

Re: Trying to add a looked-up value and DATEADD

3740 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Duncan_Fischer
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to a similar thing, but instead of adding an INTERGER for the multiplier in the DATEADD formula, I am trying to pick up a value form a table LOOKUP.

Have also tried with a FORMULA cell and it doesn.t work either.

I have different categories of appointments to book, that each have different duration and priorities

TIA,
Duncan

19 Replies 19

Hi,

DATEADD( ThatDate, VALUE(lookup value), ‘day’) shows #ERROR but DATEADD( ThatDate, lookup value +0, ‘day’) works for me.

Cheers

Fred

Larrissa_Cunnin
4 - Data Explorer
4 - Data Explorer

Hi,

I am trying to something similar I think, I have tried all of the above but not working

Screen Shot 2020-06-26 at 10.58.59 am

I am trying to add a unique “feed frequency” to auto calculate the “Next feed date” and using the DATEADD formula is not working for me.

This is what I was trying: DATEADD({Last Feed Date}, {Feed Frequency}+0, ’day’)

Any suggestions?

Just after I posted this I found the answer over here:

Until the bug is solved, that should be stated in the help articles themselves! That info shouldn’t be here and here alone.

BTW, how’s that bug solving going? It’s been at least a year and a half already?

I don’t work at Airtable :man_shrugging:

I know. But I thought that, since Airtable support has already been mentioned and the big is real, AT staff would be actively participating in this thread.

Naive me?

Such a strange bug, but glad the workaround works. Any chance that this is going to be addressed?

Ruslan_Romaniuc
4 - Data Explorer
4 - Data Explorer

Hi there!

I try to use DATEADD to calculate customer “Due Payment Date” based on the order “Ship Date” and picking up values (LOOKUP) from another table since I work with various payment credit terms: 30d, 45d, 50% in 30d / 50% in 60d…

I use positive Integer numbers for the payment terms (30, 45…) and the formula works fine:

DATEADD({Ship Date},VALUE(ARRAYJOIN({Terms 1}),‘days’))

However I have cases with split payment terms like 50% before Ship Date and 50% in 30 days after Ship Date. As said above the formula for “after Ship Date” works with positive Integer lookup values, and I’m struggling to make the same formula work for the advance payment (50% before the Ship Date) - I tried to use in the Lookup table negative Integer number for advance payments. But the problem is the #ERROR in the DATEADD formula whenever I use zero or negative value in the Lookup table instead of positive integer.

Can anyone help please?

Also if anyone knows a way how to manage due dates for split payment terms (for ex. 30/60/90/120 days for one order) without creating separate columns for each payment term and % value it would be of great help!

@Elias_Gomez_Sainz @W_Vann_Hall can you please suggest if there’s any solution to my need?
Thank you

thank you for the solution! I was getting crazy other this simple “bug”.