Help

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

Create and populate a cell if checked

Topic Labels: Formulas
463 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1

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)