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.
Hello there,
I’m trying to write a formula that calculates the sum of values in another column. The tricky part is I want each row to add only the numbers above it in this other column, adjusting each time it goes down the row. For example:
DATE ...
Hello y’all,
I’m writing out a formula that will generate dates. The dates will be based off a different calendar field in my table, and will be adjusted based on a dropdown menu. There are two formulas I’m attempting to use. The first is as follows:...
Hello y’all. I’m trying to setup a table so that dates can change in a column based on data in the other column.
Here’s how it works.
In one column is the Overall Due Date for a task (let’s say it’s August 20th). In the next column, I have a dropdown...
The goal is for it to live in a single field, and for this one date to change based off what’s happening in two other fields. What I want is to generate a date based on what’s in this “Status” field. The issue is that depending on which item has been...
Oh that did seem to work! My other question then is if I wanted the formula to include both of these formulas I’ve written (both the dates based off the "Record Date’ and the dates based off the “Upload Date,” should I simply list them both separated...
This is so helpful, thanks Kamille! Question for you. So, extrapolating for this formula, for a different table, I wrote out this formula:
IF({Recording Date},DATEADD({Recording Date},SWITCH({Status},‘Outlined’,-3,‘Script Writing (including editing)’...
