Hi all,I'm wondering: Do any of you Airtable experts have an idea how I could calculate how many Fridays (or any other weekdays for that matter) there are in a given month?
Hi,I tried using != Blank() and NOT(Blank()) on several occasions for my formulars and have been getting different results. I'm not sure why.Is it because only one of the two works and the other is ignored by my formular? Or does it depend on the for...
Hi everybody,During my continued transition from Google Sheets I encountered a problem that I can't really find a solution for (or I am not understanding the other posts on this).Here's he situation: In Google Sheets I have three sheets - orders, cus...
Hi, all. I'm transitioning from Google Sheets and I understand things are different here, so please have patience with me :-). I am basically trying to implement a VLOOKUP functionality.I have the following use case: I have two tables, customers and ...
Well, if I look at the documentation (https://support.airtable.com/docs/identifying-blank-values) I would have to write Price = Blank(), to check if it is blank. And I am interpreting, that != Blank() would be the way to check if it is NOT blank. But...
Thanks for this. Those are pretty much the ones I used to get to this point. I was just stuck trying to convert a user's input (Monday - Sunday) into a WEEKDAY, to perform the final step of the calculation.
I figured that if I can find the weekday of the first day on a month, I can calculate how many days it will take to next friday. If I subtract the difference from the total number of days in a month, divide the result by 4 and add 1 for the first fri...
