I have been pulling my hair out, new to workflows. Trying to set the value of a status column (choices: Completed/Closed; Past Due Need Assistance; Approaching Due Date - Focus Needed; On Target) based on value in a calculated column.
My calculated column is named Complete Date Empty and is
=IF(ISBLANK([Complete Date]),"Yes","No") set to single line of text.
Then I set a variable workflow called Complete Date Empty and set value to No.
If the workflow variable of no equals the calculated column then I want my status set to Completed/Closed. When the workflow runs it sets the current item always to Completed/Closed, even when the calculated column is Yes.
What am I doing wrong? Thank you!!