Hello there! I've built a Base to track "Vacation Requests" and 'balance vacation days' in two simple tables:1) Staff: where fields are name, email, role, hired date, accrued days (formula based on hired date), used days (roll up from the sum of all ...
Hello! I'm trying to avoid using Google Forms to keep everything in Airtable, but have some trouble creating the matrix-like question in Airtable Forms (check attached image). Is there a way to create this or is it impossible? Thank you!
Hello Community,I have to change Workspace Collaborators in the Organization, to Base Collaborators. Anyone knows if by doing this it triggers any billable change? Will Airtable charge us again now that they are Base Collabs? Thanks!
Hello, I'm trying to create a Formula that will change Status according to the fields "Start Date" & "End Date". If Today > End Date = "Delayed"If Today < End Date = "In Progress"If Today < Start Date = "Planning"I have written the following formula ...
Hey there Dan! Thanks for the suggestion! I was super stuck! I've added a few extra details to your approach, in order to make the whole system "Dynamic" so it's always recognizing the "Current" period for each staff member. This way 'Vac Yr Start' i...
Thank you again @Ben_Young1 this is perfect! I think after spending a few minutes I now also understand the logic behind. It's a good time to import that Formulas Base that's around and study them in depth heheThank you!!!!
Hey @Ben_Young1 I'm trying to add a "Done" to that field, based on a value in an added single select field named "Completion" (Yes, No). The idea is that when the field is changed to "Yes", then the Status field changes to "Done". I tried with the IF...
