Help Pulling Information

EMMJ

Hi,
Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer from one of the columns. I'd like to pull information from 3 sheets into one based on what is listed in one column and in certain rows.

kowal

hi @EMMJ,

Yes you can set the formula in one sheet to mark (like checkbox) only those rows that are not unique and move them or copy them with workflow to another sheet.

Paul Newcome

You should be able to make this work with a row report:

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

.