Help Pulling Information

EMMJ

Hi,
NEWBIE. I need help pulling information from 3 different sheets. I want to look at a group of rows (for example, rows 31-93, rows 31-90 and rows 33-91 in the 3 different sheets). I want to pull the all the information in the row only if the status is not N/A or complete. And I want to add a column that references the three sheets as Project A, Project B and Project C. Does that make sense? Can this be done easily for a new person?

kowal

hi @EMMJ,

i think I already responded to your different post.

Yeah it's pretty simple. You use Move Row Workflow (or copy row workflow) and in conditions you can setup to be moved to one sheet from 3 different sheets.

Paul Newcome

A Row Report should also work for this, s easy to set up, and will keep the data synced.

https://help.smartsheet.com/learning-track/level-1-foundations/reports

.