Need an HLOOKUP or similar
Does anyone have a formula that will evaluate all the cells in a row, then return the column name for the cell that has a particular value?
Here's what I am trying to do. I have a Smartsheet with 23 columns, of which 5 are due dates. A 6th date column is "Next Due Date" and contains a formula that evaluate the other 5 date columns and returns the next one that is upcoming but not past. I would like to write an additional formula that lets me know what column that date comes from. For example, my existing formula lets me know that the "Next Due Date" is 12/15/18, and the needed formula would tell me that 12/15/18 is in the "Proposal Due" or "Interim Report" or "Final Report" column.
Comments
-
You can't pull a column name in Smartsheet directly like that, you have to add a row (I usually go ahead and put it up top) and re-enter the column names across that top row. You can then use an INDEX/MATCH set-up to reference [Column Name]$1. This will pull whatever data is in the first row of the column which ends up being the column name that you manually entered.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!