A workflow has become invalid

Pierre-Eric Collette

Hello,

I need some help here. Here is a message I receive

I have a condition in "Phase 3a" workflow that triggers a comment written in a given cell.

Ideally I’d like a date to also be recorded while triggering this comment but it doesn’t seem possible as the desired field doesn't come up in the action drop down list. 

To overcome this "issue" I’ve then created another workflow triggered when a comment is read & the date field is empty.

This works as it writes a date but it also disables the workflow :[]

 Could you help me ?

Thanks for your support

Pierre-Eric

Genevieve P.

Hi @Pierre-Eric Collette

Both workflows have the same trigger, and it looks like that trigger is when anything happens on that row. Try instead to change your second, small workflow to have the trigger of:

When Gate 3b owner approval changes to Not Applicable. Have it be the actual trigger instead of the Condition, does that make sense? Then it will only run if the Owner Approval changes to Not Applicable, whether that's done by a workflow or done manually.

Cheers!

Genevieve

Genevieve P.

Hi @Pierre-Eric Collette

What is the trigger for the Comment workflow? It sounds like it might be when anything is changed, which is why it's being disabled when the date changes the row, as otherwise it would be a constant loop.

Could you post a screen capture of each workflow? We may be able to adjust the triggers so this loop doesn't happen.

Cheers,

Genevieve

Pierre-Eric Collette

Hi @Genevieve P.

Thanks for your answer.

Here is the WF Phase 3a that writes a text to dismiss a future interim step not needed with specific conditions..

Indeed the trigger is "if any changes happen on the sheet anywhere".

This allow me to run the logic at any point when a user changes a date, a comment etc.

SMartsheet WF.pdf

Phase 3b WF does the following:

if the cell where WF Phase 3a wrote "not applicable" is found then it also writes the date when this comment was written. This date is later used to tell whether a Phase is terminated or not

To be honest I don't see where there is a loop but I can very well be wrong !

Many thanks for your support

Cheers,

Pierre-Eric

Genevieve P.

Hi @Pierre-Eric Collette

Both workflows have the same trigger, and it looks like that trigger is when anything happens on that row. Try instead to change your second, small workflow to have the trigger of:

When Gate 3b owner approval changes to Not Applicable. Have it be the actual trigger instead of the Condition, does that make sense? Then it will only run if the Owner Approval changes to Not Applicable, whether that's done by a workflow or done manually.

Cheers!

Genevieve

Pierre-Eric Collette

Thanks @Genevieve P. It looks like a good suggestion. I'm implementing :)

have a great day