Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

Jeremy Morris
edited 12/09/19 in Archived 2015 Posts


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.



  • JamesR
    JamesR ✭✭✭✭✭✭



    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.

This discussion has been closed.