I want to measure workload in a week. TABLE 1A) i use google calendarB) In airtable DATETIME dif give me the duration: 02:00C) The weeknumber is a formula week(Start) = So i get Week 2022_5TABLE 2 This contains only weeknumbers: 2022_552 problems:a:...
I try to figger out this automation, not found yet how to 'set a field with a formula' when something was triggererd. An idea is indeed if a record is created the value of the formula is set into a number field. But it feels strange that i can't use ...
