Sign in to join the conversation:
Hi All
I am trying to get a formula working whereby if
Many thanks
Give this a try...
=IF(AND(Status@row <> "Complete", [End Date]@row >= TODAY(-3)), 1)
=IF(AND([End Date]@row <= TODAY() + 3, NOT(ISBLANK([End Date]@row)), OR(Status@row = "In Progress", Status@row = "Not Started")), 1, 0)
Broken down:
=IF(
3 Criteria AND statement
AND(
First criteria end date is within next three days or in the past
[End Date]@row <= TODAY() + 3,
Second criteria end date is not blank
NOT(ISBLANK([End Date]@row)),
Third criteria: opens or statement that returns a true if status is in progress or not started
OR(
Status@row = "In Progress",
Status@row = "Not Started")
),
Returns 1 if criteria is met, 0 if not.
1, 0)
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…
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…
