automated workflow

minh.h.nguyen

Does anyone know why my automated workflow does not pull all the information to new sheet?

This is my trigger and action.

see column 6 row 1, that did not get pull over. Why?

Andrée Starå

Hi @minh.h.nguyen

I hope you're well and safe!

What's shown in the source sheet?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

minh.h.nguyen

UMXU932476

Andrée Starå

@minh.h.nguyen

Have you checked the Activity Log and Cell History for clues?

minh.h.nguyen

no, I do not even know where to find the activity log or cell history. Where is that at ?

Andrée Starå

@minh.h.nguyen

https://help.smartsheet.com/articles/2476206-track-sheet-changes-with-activity-log

https://help.smartsheet.com/articles/518314-viewing-cell-history

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

minh.h.nguyen

Andree,

I looked through the cell history and activity log. For some reason it is inserting 2 new columns and copying the information that is missing into one of those column but that is not part of my workflow. see my automated workflow from above for conditions and actions I set. This is what it is doing

Do you know why it is inserting these 2 columns instead of doing what the workflow tells it to do?

Andrée Starå

@minh.h.nguyen

The added columns were probably added to the Source sheet, and when it copies over, it adds all the columns, even those that weren't added before.

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

minh.h.nguyen

Andree,

there are not added columns on the source sheet though.

Andrée Starå

@minh.h.nguyen

Ok, but the added columns were already available in the source sheet. Correct?

minh.h.nguyen

the added columns are in the source sheet but not the extra ones.

first pic is the source sheet with trailer and comment column, second sheet it got added another trailer and comment column to it. Why did it add the extra columns when I did not put that in my workflow?

Andrée Starå

@minh.h.nguyen

It looks like someone changed the name of the columns, and that's why they were added again.

Trailer #, Trailer

Comments, Comment

Make sense?

minh.h.nguyen

got it. it was right in front of my eyes! you're a genius Andree, Thank You!

Andrée Starå

@minh.h.nguyen

Excellent! Thanks for the kind words!

I'm always happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!