So I found a formula someone else made that does exactly what I need it to do. I need to display the dates of certain events as "week of" so I can group the event by the week and see how many posts are made during the week. The problem with the for...
I built a task management table that tracks, start, due, and completion dates.The start date is logged by an AT automation that pulls from a field called Todays Date. That field is set to PDT in the field options.The due date pulls a unique SLA from ...
Apologies in advance if this is elsewhere or common knowledge or the query is posted in the wrong location (Formulas). I did look all around to find a similar Q&A elsewhere (found some close but none exactly what I was looking for), so...TWO sample u...
I just found out that both SET_LOCALE and SET_TIMEZONE functions returns an incorrect hour, at least for Europe/Lisbon and en-gb as per the below examples:SET_TIMEZONE(NOW(), 'Europe/Lisbon')SET_LOCALE(NOW(), 'en-gb')Both these functions as returning...
Hey all - I'm running a formula column with a lot of IFs in there. Only 1 out of the 6 possible responses returns a text field, the rest are date fields.The dates come out in a very ugly way, this is how it looks: 2023-07-12T23:06:37.000ZIt basically...
I am building an implementation plan for my projects split by a 2-week sprint cycle. While I was able to get Week number from date of delivery, I am stuck trying to covert it into a Sprint number.
Hi all. I'm trying to create a formula field that will calculate if the date should be the 1st or the 15th of the month based on another date and time field that can be any day of the year.If the date field is any date between and including the 1st a...
I am trying to figure out how to create a field that will update every time the "CLIENT STATUS" field is changed and maybe another field that says how many days that record has been in that status. Any ideas? Thanks!
Hi All, I'm working on a base that needs several fields to be adjustable to display a date or text. Right now the date is being pulled from some formulas but the text is an option should the user need to add a note there instead. I'd really like to k...
I have data that I am importing from a CSV. Sometimes it will import into my date field without issues, and other times it will simply be blank. In the screenshots I have attached, the left column is an Airtable date field (screenshot of settings att...
