'If' Formula that Pulls Data from One Cell in Different Sheet

Jeremy Morris

Hi, 

I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. 

 

Has anyone made a reference like this in Smartsheet? 

 

Thanks so much for taking a look at this question.

Jeremy

JamesR

Jeremy,

 

You cannot do exactly what you want how you want it, but if you add a column in the Old sheet and put the if function in theat on the relevent rows so the answer is in the cell.  You can always hide the column if you do not want people to see it.  In the new sheet link the cell you want the anser in to the relevent cell on the other sheet that has the answer.

Inshort, create the answer in the old sheet and link to from the new sheet.