Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Oct 09, 2019 12:24 AM
I have a budgeting table with earnings and outcomes, so for the monthly payments (like subscription etc.) I’d live to have that at a certain date a cell duplicate itself. I was thinking to use a checkbox so if it’s checked than it duplicate periodically, but I can’t figure out the right formula. Can you help me?
Oct 09, 2019 08:46 AM
by duplicate, do you mean multiply? For instance if there is a monthly charge beginning on October 1st of $15, the cell should show $30 on Nov 1, $45 on Dec 1st, etc.?
To do the above you will need a defined start date and a formula a little something like this:
IF({Checkmark Field}, {Charge Amount Field} * DATETIME_DIFF(TODAY(),{Start Date},'months'),0)