The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I'm wondering if there's a way to allow users configure fields from within an interface? e.g., my use case is that a certain user needs to be able to adjust Kanban columns on the fly by changing available values in a single-select field. They could d...
I have a User field that allows multiple users to be tagged. I'd like to write a formula that will pull those people's first names into a comma-delimited list. I came up with the following:LEFT({Users}, FIND(" ", {Users})-1)...which does the trick if...
I'm trying to set up a formula that will give me the date of "Monday" relative to a given record's date. So if a record was dated today Wed June 21, I'd want the formula to give me Mon June 19.I've done some searching on the forum here and found this...
I have a sort of complicated question about how date formulas treat the concept of a 'week.' This formula also considers the week to be Sunday thru Saturday:DATETIME_FORMAT(Date, 'w') For a record dated Sunday June 18, the value returned here is 25. ...
Hello! I have 4 date fields, and for a given record, any of the 4 could be filled in (or several of them, or all of them). I've written a formula to return 'Y' if any of the 4 dates fall within the current week. Here's what I've got:IF(OR({Date 1}, {...
That makes sense, but in this case, I'm using a Collaborator/User field that links directly to Airtable users, rather than using a linked record to a separate Team table.
Sure thing @Sho! If the list of contributors is:Jane Doe, Joe Smith, Johnny AppleseedThe output should ideally be:Jane, Joe, Johnny@Sho wrote:Hello, @kts Yes, it is true that REGEX is difficult to understandCan you show a few examples of inputs and i...