The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Hi,
I have these functions in two fields:
Field “Dani”:
DATETIME_DIFF({Od},{Do},'days')-1
“Od” field is a date without time, and “Do” is also a date. Sometimes they could be the same dates.
Field “Test date function”:
IF( Smena=1,Dani-1, IF( Smena=2,...
Hi,
This is my idea:
To create a base which would be used to link and organize things for the company, like: Production Machines, Workers (or Employees), Products, Stock, Customers, and Orders. In a way that I would have linked tables to organize rel...
Yes, {Smena} is the shift. The shift changes weekly. In the way that the Employee who worked the first shift (6am to 2pm) on Friday becomes second shift (2pm to 10pm) on Sunday, and the one who worked second shift on Thursday becomes third shift (10p...
Thanks for reply.
WORKDAY_DIFF() exclude weekends and that’s it. I needed the exclusion to happen based on “Smena” field condition. And the problem is that if the length between dates is 14 days or more, for example, “Smena” is not the same anymore f...
OK. Good! Very useful!
By the way, when you said in your first reply
Justin_Barrett:
but not just because of how that affects the value in the “Smena” field
Smena is not affected by length of time between Od and Do. Smena is changed weekly reg...
Thank you for reply!
Yes, I was checking SWITCH function too. It should be more simple than IF, but I actually didn’t get how it works :slightly_smiling_face:
And how do I nest SWITCH function? Is that possible at all? Like, let’s say the function ...