Cell reference formula

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

Find more posts tagged with

Sheets

Formulas

Comments

Is this what you're after?

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

Hi Brett - the sheet you posted is blank

Sorry Ian - It is updated now.

Not exactly Brett, see if this makes sense

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

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.

Sign in to join the conversation!

Quick Links

Trending discussions