Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to search a number with a date

299 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

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 !

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.