Cell reference formula

Ian

How can I create a formula from two columns that will result in pulling in the value from a third column?

 

Column1 (text) = Column4

Column2 (text) = 3

Column3 (date) = Column1 + Column2

 

Ideal Column3 result = [Column4]3

 

 

Please let me know if I can clarify anything, it is a little confusing.

 

Thanks

Brett Evans

Is this what you're after?

 

https://app.smartsheet.com/b/publish?EQBCT=fc8664bec2594c868bd5b4a9e6e712c8

Ian

Hi Brett - the sheet you posted is blank

Brett Evans

Sorry Ian - It is updated now.

Ian

Not exactly Brett, see if this makes sense

 

https://app.smartsheet.com/b/publish?EQBCT=f84b05d13b3d42198866fd4344147063

 

Travis

Hi Ian! While you can concatenate text from the two cells, the result will be a text value - not a cell reference. There may be a workaround we could suggest if you gave us information on your use case for wanting this functionality.