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 reenter the column names across that top row. You can then use an INDEX/MATCH setup 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
Check out the Formula Handbook template!