How to reference column name pulled from formula

I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from?

My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should pull the value from Day 0 Start3 Date. Instead, it's pulling the text "Day 0 Start3 Date". Can I have the column name be used as a string instead of text?

="[" + INDEX([Index Date Row]:[Index Date Row], MATCH(Index@row, [Index Lookup]:[Index Lookup], 1)) + "]@row"


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Are you trying to use that as a dynamic cell reference? If so, that is not possible. What it looks to me like you need is something more along the lines of

    =INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)

    You are going to need to update the column names in the formula to match what you are using in your sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!