This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hey guys!
I would like help to develop a formula that would give me the day “02” closest to the date of a specific field. For example: If in the {Purchase day} field the date is 02/25/2021, I would like the formula to show me 03/02/2021, if {Purchase...
Hello guys!
I would like help creating a “Monthly Billing” table.
The question is: I have a table called “Jobs” where I add all the jobs that my clients ask me for, this table contains several columns, including a “month/year”, and also a column refe...
Hello guys!
I would like help creating a “Monthly Billing” table.
The question is: I have a table called “Jobs” where I add all the jobs that my clients ask me for, this table contains several columns, including a “month/year”, and also a column refe...
Hello guys!
I would like help to do a subtraction according to the values that are being established.
The situation is as follows: I work in credit format with my clients, so they start the month with 8 credits, as they request me, I establish the ...
Hello guys!
I’m new here and I’m still learning about Airtable, but I’m really enjoying it!
I have some doubts about formulas, I would be very happy if they work for what I need, here are my doubts:
1 - Is there any way to add numbers in a column aut...
Excellent explanation, Alexey!
I’m understanding the formulas better now, my goal is to try to make my formulas as organized as possible to avoid getting lost in their own mess hahahaha
Your SWITCH idea was very valid, I hadn’t thought of using it th...
Excellent, Alexey!!
Your formula works perfectly, I really appreciate your attention.
I made some small adaptations thinking about my holiday context and language (if I decide to use the ‘MMMM’ format), see what you think:
DATETIME_FORMAT(
SET_TIMEZO...
Hi Alexey!
Forgiveness! I was wrong, I just edited the post.
Just explaining my idea a little better: I would like that whenever I add a purchase with a credit card to my table, the formula will return me the next invoice closing.
Thank you very much...
Hi Kamille!
Right! I would like help to build a formula with 2 conditionals, the idea is that it shows me “Yes” if it is the first day of the month and if the Status column is written “ :heavy_dollar_sign: Installment”. The idea is that the answer “...
I thought of a solution!
I thought of creating a column called “First day of the month” with a formula in the “Operating Costs” table that does the following: If today is the first day of the month and the Status is “ :heavy_dollar_sign: Installment...
