Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to search a number with a date

787 3
cancel
Showing results for 
Search instead for 
Did you mean: 
bguiraud
4 - Data Explorer
4 - Data Explorer

Hi

I want to search a number with a date, like this :

bguiraud_0-1727267724330.png

 

Can you help me ?

Thanks !

3 Replies 3
BillH
9 - Sun
9 - Sun

I might be guessing wrong on your goal, but it seems you could create a column as a link to a pipeline record, then modify the "Benefices Prev." column to be a lookup to that link with the output being the value from "Calcul" in the lookup record.

You would either have to manually link the record when you create a new row or set up an automation triggering on the new row creation to populate the row.

Hi.

Thanks.

Have you got an exemple of formula ?

Because I don't see how to do that ðŸ¤”

I need to create a link record in another table ?

Thanks !

BillH
9 - Sun
9 - Sun

There is no formula.  

You create the link to the record in the same table not a different table.

Airtable isn't a spreadsheet, so you need the link in order to do a lookup to other records in the same table, but usually that involves adding an automation to populate the links as you add records unless you build it into a form or interface.