Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: DateAdd Function

206 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Zak1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,  

I am trying to create a formula to put together a date we expect something to be completed.

Date to Client is entered by my team and is the first part of the equation.

Client Timing is pulled as a lookup field from another table dependent on each client as is based in days.  

Formula I have is 

Dateadd({Date to Client}, {Client Timing}, "days").  This equation is taking the client date (ex 12/2/25) and always subtracting one (ex 12/1/25.

Is there a different formula I should be using for this type of transaction?

4 Replies 4
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @Zak1,

What is the issue with your current formula? Is it not working?
If so, you might want to try using a rollup rather than a lookup for Client Timing just in case. For the formula you might want to use Arrayjoin, Sum, or Max depending on your use case.

Lookups might be treated as Arrays by Airtable. 

Zak1
5 - Automation Enthusiast
5 - Automation Enthusiast

The formula is always just subtracting one from the current date and not using the number in the lookup (ex. 10).  I will try a rollup to see if that may work.  Thanks.

 

TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right? 

Screenshot 2025-02-11 at 12.30.43 PM.png

 

DATEADD(
  {Date to Client},
  {Client timing (from Clients)} + 0,
  'days'
)

 

 

Alexey_Gusev
13 - Mars
13 - Mars

To summarize the solution from @TheTimeSavingCo , lookup is Array
sometimes you can use it it formulas as is, but sometimes you need to use
{Lookup} + 0  to convert Array to Number
{Lookup} & ''  to convert Array to String

alternatively, you can change it to Rollup with array function,
SUM(values) for Numbers
ARRAYJOIN(values)  or ARRAYUNIQUE(values) for Strings