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.
Hello!I am trying to create a formula which gives an output of difference between two dates (Premium date & Last month from Today date - as seen in the last 2 columns). The base is primarily used to manage my Insurance payments, so keeping that conte...
Hey!
I was trying to group the weeks by the month, so like if I have a Date, I want to get the weeknum in which the date falls WITHIN that specific month only.
Eg. - 1/6/22 - it should show as 1 - since it comes in 1st week of June.
I read up and tri...
I have a column named Day name which is a single select field containing names of day - Monday, Tuesday, etc.
How can I create another column which gives the weekday number of this? I know I need to use Weekday() function, but how can I set it up suc...
Hello people!
I am trying to setup a table which will contain reminders for when I want to connect with my clients.
Basically, I want to setup weekly/fortnightly/monthly reminders based on day of the week.
Like so -
Weekly - Thursday,
Monthly - 1st w...
So I have a base with 2 tables - one containing the funding round details (FRD) which includes name of Startup, amount and investor
And another table solely for investors - which I wish to import data from Investors column in FRD table.
Now, the inve...
Hey Stephen! Thanks so much for the solution! The reason I'm adding the datetime_format is because I want to omit the year in the dates and only consider DD-MMM.Thank you so much!
Hey Adam, I think I’ve solved this.
I’ll explain in case anyone stumbles across same issue in future.
Basically, I had setup daily/weekly/monthly reminders - which are not based on a specific date, but based on specific week and day - say 1st week Fr...
Adam_TheTimeSavingCo:
Ah okay. This seems pretty complex and I don’t really understand what we’re trying to do. Could you provide an example of the reminders you would want sent in a month perhaps?
Yes Adam.
I’ll share a sample base with you h...