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)
Is there a trick to creating a column of unique values for each row that will not change after it is created? I cannot use Auto-ID because the row then gets copied to another sheet that utilizes Auto-ID and Smartsheet limits that. I'm stuck and ChatGPT keeps making recommendations that don't work.
I have a sheet that has all of our orders on it. I have other sheets "Gantt" for each machine. I want each machine sheet to auto populate every order that is assigned to it, when an order gets assigned to the machine. I don't want to set an automation to copy the row from the orders sheet to the machine sheet because I…
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…
