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