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.
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
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.
