Sign in to join the conversation:
I want a new column to reflect the date 7 days before an existing due date column. What's the formula?
Hi Tyler,
Try this.
=[Due Date]@row - 7
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
That worked! Thanks!
Great!
Happy to help!
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
I'm trying to find and number in the Rank column the last two rows that have a status column with a check in the checkbox. I am using the following formula but am getting a #INVALID OPERATION error. =IF(AND(Status@row = 1, [Row #]@row >= LARGE(COLLECT([Row #]:[Row #], Status:Status, 1), 2)), 1, 0) The properties for each…
Objective: Status column is a drop-down. The cells in the Status column have a formula using Descendants, with the idea that when the descendants tasks are all marked with the same status, such as "Completed," then the ancestor to those descendants is also auto-marked as "Completed." Example: See screenshot below. When…
