Conditional Link/sheet

Ali Naderi

Good day,

 

I am a user of Smartsheet and am wondering if you guys can assist.

 

First I will try to draw your kind attention to the task I would like to do in smartsheet, as below:

 

Sheet 1

ITEM         DESC          COST1               COST2                BCOST        DATE            PERCENTAGE                                        

AA             WOOD       £12.00               £13.00               £12.50        12/4/16           12%

CC              FOOD       £15.00                 £11.00               £12.50        12/4/16           9%                                         

 

 

Sheet 2

 

ITEM                      DESC                      BCOST                   DATE                     PERCENTAGE

AA                           WOOD                  £12.50                 12/4/16 12%

 

Suppose that I have sheet 1 above an dam keep updating it base don’t he information/columns.

Now I want to create another new sheet (Sheet 2) to have only the selected columns/info from sheet 1.

Once I am completing the row/information in sheet 1 and once the percentage shows 10% or 10% plus it will automatically populate the information into sheet 2 without my action. So each time I visit sheet 2, it is automatically full of the information extracted from sheet 1 for items with more than or plus 10%.

 

Was I clear?

 

Can we do such things in smartsheet and if yes, would you please advise me the best easy way to do this?

 

Regards

Ali

Suzanna Diebes

Hi Ali,

I believe what you are trying to do is cell linking. Please refer to this tutorial.

 

http://help.smartsheet.com/customer/portal/articles/861579-cell-linking

 

Hope this helps!

Mike Blumenstein

Ali,

 

What do you need to do with the data on Sheet 2? Are you just viewing it or do you need to do further calculations on the data?

 

My vote might be just to use a report pointed at Sheet 1 to filter the items when Percentage is greater than .10 (10%). It would then only show you the rows that are greater than 10%, and you can also only show the 5 columns you want from Sheet 1 in Report 1.

 

Hope this helps! 

 

http://help.smartsheet.com/customer/portal/articles/522214-creating-reports

Ali Naderi

Hi Mike,

 

Thank you for your comment. Yes this is exactlky what I am trying to achieve. I only want once I start entering data in Sheet 1, once I have entered the percentage equal or greater than 10% and finished the row, it would automatically populate the row information into the blanked sheet 2.

so at the end in sheet two we have a bounch of information which only reflected the rows with equal or greated than 10%.

 

Please advise.

 

Regards

Mike Blumenstein

Here is the example I built in Smartsheet given your requirements above.

 

Ali's Sheet (Sheet 1) would have ALL of the columns and information.

 

You should have everything you need (I shared you to the sheet and report I created for these screen shots). Feel free to request ownership of those anytime.