Column Heading - MATCH

Mike B

Can Smartsheet MATCH the Column Headings to determine where to populate a cell? i.e.

Match the Heading with a cell value to get a value from the matching row.

Georgie

Hi @Mike B,

It sounds like you’re looking to reference the column names within your formula. This isn’t currently possible, but I found a similar idea post here:

• @Column Reference

Please add your vote to this idea if it matches your request. You’ll then receive updates when the status of the idea changes! If the request provided doesn’t quite match your suggestion, please create a new Idea Post in the Smartsheet Product Feedback and Ideas topic. This will allow other users to vote on your enhancement idea!

You could, however, add a row at the top of the sheet which contains the formula. In the row, you’d add the names of each column - you can then reference these cells in your formula. However, you won’t be able to convert these to column formulas, since they’ll contain cell references.

For example, if this is the sheet you’re referencing: 

Then the sheet that contains your formula would look something like this:

Alternatively, you could create sheet summary fields with the column names and reference the sheet summary fields in your formula. You would be able to convert these to column formulas, but since the formula is using a sheet summary field, it will always match on the same column name. This idea is discussed in more detail on the idea post I linked above if you wanted to explore it further!

Hope that helps - let me know if I’ve misunderstood your question! If I have, it'd be great if you can include some screenshots of your sheets so that we can understand what you want to achieve.

Thanks, 

Georgie

Mike B

Thanks!!!!!

Paul Newcome

Are you able to provide more details? What exactly are you wanting to accomplish?

Georgie

Hi @Mike B,

It sounds like you’re looking to reference the column names within your formula. This isn’t currently possible, but I found a similar idea post here:

• @Column Reference

Please add your vote to this idea if it matches your request. You’ll then receive updates when the status of the idea changes! If the request provided doesn’t quite match your suggestion, please create a new Idea Post in the Smartsheet Product Feedback and Ideas topic. This will allow other users to vote on your enhancement idea!

You could, however, add a row at the top of the sheet which contains the formula. In the row, you’d add the names of each column - you can then reference these cells in your formula. However, you won’t be able to convert these to column formulas, since they’ll contain cell references.

For example, if this is the sheet you’re referencing: 

Then the sheet that contains your formula would look something like this:

Alternatively, you could create sheet summary fields with the column names and reference the sheet summary fields in your formula. You would be able to convert these to column formulas, but since the formula is using a sheet summary field, it will always match on the same column name. This idea is discussed in more detail on the idea post I linked above if you wanted to explore it further!

Hope that helps - let me know if I’ve misunderstood your question! If I have, it'd be great if you can include some screenshots of your sheets so that we can understand what you want to achieve.

Thanks, 

Georgie

Mike B

Thanks!!!!!