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

Need help with setting up a formula that keeps adding

Topic Labels: Formulas
680 4
cancel
Showing results for 
Search instead for 
Did you mean: 

I would like to create a formula that adds a certain number per day. For example:

Lets say I have a field that starts with 8000 and I want the field to increment by 44 each day. I dont want to add a new row each day, I simply want the same field to go: 8000 today then 8044 the next day, then 8088 on day 3. Is this possible?

How would I go about this? Is there a simple way to simply add 44 each day? Or do I need to create a 2nd table that has pre-populated dates and numbers that go up by 44 (88, 132, etc) and the first table references the 2nd table somehow?

I’m really terrible with excel/airtable formulas and logic :frowning:

Any help would be greatly appreciated!

4 Replies 4

8000+44*DATETIME_DIFF(TODAY(),{START DATE},“days”)

Where {START DATE} is a Date field that contains the date you want to start counting from.

Awesome, totally makes sense! Seems so simple now that I see it.

Thanks for the quick help!

How do I add text to the end of this? So say I’m counting widgets how would I have the formula show 8088 Widgets?

I’ve tried doing it with concatenate but maybe my syntax isnt correct.

Try

(8000+44*DATETIME_DIFF(TODAY(),{START DATE},'days'))&' widgets'

Concatenating a number and a text string converts the number to a numeral and appends the text. (The enclosing parentheses aren’t required; I’ve included them here simply to differentiate between the numeric and text portions of the formula.)