Sharon_Visser - profile

Sharon_Visser · Dec 03, 2024

I created an interface dashboard with several groups (different charts, different numbers, etc.). For aesthetic reasons (making the data make more sense to execs), I would like to have 2 groups side by side. For example, I would like to have a YTD g...

Sharon_Visser · Dec 11, 2023

Hi, I am trying to count the number of months from the Start Date till today. The actual day of the 'Start Date' doesn't matter. For example, if 'Start Date' is 9/20/23 and today is 12/11/23, I want to count the number of months that have passed: S...

Sharon_Visser · Mar 16, 2023

Hi Airtable Community -I have table A which has a column that stores links to records in table B. When I am in an expanded view of a record in table A and I click on the linked entry to open the linked record in table B, what determines what view is...

Sharon_Visser · Jan 09, 2023

Happy New Year, Airtable Community!Each year I document my Airtable environment. Does anyone know if there is an easy way to obtain a list of synced tables (with source and destination) that would save me the effort of going into each base to look fo...

Sharon_Visser · Aug 31, 2022

Hi all - I know dates and timezones are complex, and I’ve tried to do my homework but I’m really stumped. My end goal is to identify records created yesterday and send off a notification. To start, I’m attempting to calculate how many days are betwe...

Sharon_Visser · Dec 04, 2024

Thank you, @TheTimeSavingCo , I'll figure out something similar to your solution to display the data better. It would be very helpful if Airtable added elements like text and spacers so we can make the displays more readable. I know I can do that us...

Sharon_Visser · Dec 14, 2023

Thank you, the solution using DATETIME_DIFF and DATETIME_PARSE works - though I had to add "+1" to the end of the formula. I did some testing crossing year boundaries and it works. This is a really helpful formula, I appreciate your help!

Sharon_Visser · Dec 13, 2023

Hi again, I do appreciate your help, but this version only seems to work within the same year. As soon as it crosses a year boundary it's not right. If Start Date = '9/20/23', and Today is '1/10/24', the result is -7 rather than 5 (Sept, Oct, Nov, ...

Sharon_Visser · Dec 12, 2023

Hi @Sho , I tried this and it's giving me an answer of 3 instead of 4. I think it's taking into account the days, and not just looking at months. I'm assuming someone worked even 1 day each month between the Start and today, so then I need to count...

Sharon_Visser · Mar 17, 2023

Thanks for that information, but it does raise a question for me. Can't each collaborator change the order of their views - maybe some have Favorites, maybe some don't. As an Admin/Developer - can I control the order in which they appear?Thanks aga...

User Statistics

User Activity

Moving groups in Dashboard interface

Count number of months from Start Date to today

View for Linked Record

List of syncs

Date calculations to determine "yesterday"

Re: Moving groups in Dashboard interface

Re: Count number of months from Start Date to today

Re: Count number of months from Start Date to today

Re: Count number of months from Start Date to today

Re: View for Linked Record