This workflow is not fireing eventhough the g...

[Shawn_Strahan1]

This workflow is not fireing eventhough the green check comes on for this formula in the …IF THIS IS TRUE… Condition

AND([_THISROW_BEFORE].[Delivery Status]=“IP-Delivery”, [_THISROW_AFTER].[Delivery Status]=“Complete”)

Does anyone see something wrong with this?

[Deep_Foundation]

This workflow will only fire if the “Delivery Status” field value has changed from “IP-Delivery” to “Complete”. Is that what you intend on doing?

[Shawn_Strahan1]

@Deep_Foundations

yes.

I’m sure that’s how it is changing in that cell but still no workflow.

‘IP-Delivery’ then it goes to ‘Complete’

I’ll change it up and see if i can get it to work another way.

Thanks

[Grant_Stead]

@Shawn_Strahan1 how exactly are you making the change? Through a form, an action, backend? Are you sure the workflow is set for updates?

[Shawn_Strahan1]

it is with an Appformula for that column that is getting the info from another sheet Here is the APPFORMULA…that populates [Delivery Status]

=If(AND(NOT(ISBLANK([Signature])),NOT(ISBLANK([Print Name])),NOT(ISBLANK([Working order?])),NOT(ISBLANK([KnowHow])), [SN Count eq Complete Count]), “Complete”,

“IP-Delivery” )

[Aleksi_Alkio]

Is this status column a normal column?

[Shawn_Strahan1]

[Delivery Status] is a normal column with APP FORMULA along with all the other referenced columns except. [SN Count eq Complete Count] - this is a virtual column

but I can see it has the Complete in there before i SYNC so im not sure why it wont go.

[Shawn_Strahan1]

are there common errors to look for that hold up work flow emails?

[Shawn_Strahan1]

@Aleksi_Alkio

I’ve been struggling with the Email Body Template.

If there is a problem there would that keep it from firing?

[Aleksi_Alkio]

If you have error in a template you would see that in Audit log.

[Aleksi_Alkio]

When you check the audit log and the log that belongs to this workflow, is the icon green or blue? Green means the workflow is fired and blue means it’s not.