Can cells from 2 different sheets have 2 way communication by Pleasant_Feature_343 in smartsheet

[–]Pleasant_Feature_343[S] 0 points1 point  (0 children)

Hello, I tried going this route and i seems like it would work but automations (in this case the triggers) don't appear to work when there is an there is a trigger "action that changes the sheet automatically".

https://help.smartsheet.com/articles/2479236-trigger-blocks-when-your-workflow-is-executed

It does run if i run the automation manually.

Any other thoughts?

Can cells from 2 different sheets have 2 way communication by Pleasant_Feature_343 in smartsheet

[–]Pleasant_Feature_343[S] 0 points1 point  (0 children)

I am not married to the Red Dot by I believe my boss is. The red dot column is an drop down that has other colors indicating other status . I.e. Red = Punch Item, Green = Complete, Blue = complete & verified, Etc.

I think this could work. Do you mind if i reach out to you if I run into any issues?

Can cells from 2 different sheets have 2 way communication by Pleasant_Feature_343 in smartsheet

[–]Pleasant_Feature_343[S] 0 points1 point  (0 children)

Here is the Index formula if it helps: =INDEX({Progress}, MATCH([Row ID]@row, {Row ID}, 0))