Determine follow-up date that will trigger Workflow

Hi SherryFox,

I believe the formula you're attempting has some issues, and I have a revision that should fit your criteria.

Here’s an updated version of the formula to calculate the "Workflow Follow-up" date:

=IF(AND([Certification Complete]@row <> "Green", NOT(ISBLANK([Workflow Initiated]@row)), [Workflow Initiated]@row <= TODAY(-14)), TODAY(), "")

Explanation:

1. Condition for non-green certification:
   • [Certification Complete]@row <> "Green" ensures the certification is not marked as complete (Green).
2. Condition for Workflow Initiated:
   • NOT(ISBLANK([Workflow Initiated]@row)) ensures there is a date in the "Workflow Initiated" field.
3. Condition for 14 days elapsed:
   • [Workflow Initiated]@row <= TODAY(-14) checks if the "Workflow Initiated" date is more than 14 days old.
4. Populate "Workflow Follow-up":
   • If all the above conditions are met, it populates with TODAY() (current date). Otherwise, it remains blank ("").

Implementation Steps:

1. Copy the formula above.
2. Add it to the "Workflow Follow-up" column as a column formula or in the specific rows where you need it.
3. Ensure that the "Certification Complete" column uses the exact status names (e.g., "Green", "Yellow", "Red").

If this doesn't work as intended, let me know, and we can adjust further!