HI
I have 2 tables in Airtable.
One si projects and the second table is Actions.
I created a column in the project Tables in which I set a color.
Actions are linked to a project (only linked to one project + lookup field to “color” from project table...
Hello Maya
I’m not sure I understand what you want
But if you want to return the week number of a date (eg : fieldname = “Campaign Date”) based on the first of november 2021, you can add a formula field: “Campaign Week”
1+DATETIME_DIFF(
{Campaign Dat...
