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...
