Good afternoonStill a newbie to Airtable so I appreciate the help.I have a series of tables that have a "next follow up" column and I'd like to be able to create a table that would show only those with the due date of today. In other words, it would...
Working with birthdays where I only know the client's Month/Day and not their Year of birth. So text field is 5/12 for example but I'd like to have an actual date of 5/12 so I can set up reminders 5 days before the actual birthday. I used the follo...
Hello!
I’m trying to set up an automation where a birthday email goes out on the client’s birthday. I found the solution on changing their DOB to current year (thank you community!) however, I don’t want the emails to go out before 9 AM on the day o...
Hi there. I’m trying to set up a graph that would only show the transactions that have closed up to the day but within the current month only so MTD.
I’d also like to be able to set up a graph that would show Year to Date or YTD for transactions tha...
Hi there
I would like to be able to know how many hours a tasks takes a member on my team so I can be alerted if over 4 hours. The catch is that I want to calculate only business day hours not just straight hours. Example would be if the tasks is s...
I really appreciate your help. After thinking about it I think I need to restructure my whole base and then use an interface to get me where I need to go. Have a great week!
Thank you for your reply! I'm a new Airtable user. When I copied and pasted your formula provided, it said it wasn't valid. I made a small adjustment and it was accepted but now it's changing the day by a day. Here's what I input...sure I did some...
Thanks Adam. In the base that you sent me, if/when I make a date change to the {Birthday}, the updated results in the {Change birthday to this year} says the year 2021 vs 2022. It’s correct upon original data entry so I can’t figure out what’s happ...
