- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 10:41 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 11:01 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 11:07 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 08:30 PM - edited ‎Feb 10, 2025 08:31 PM
Does this look right? 
DATEADD(
{Date to Client},
{Client timing (from Clients)} + 0,
'days'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 06:15 PM
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
