IF/Index/Match
It's Monday and I can't seem to get this one to work.
If a value populates in a cell in a specific column (this is a formula column)
Every row that contains this data (All the columns) it would fill in the data that's listed in the formula column.
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
Answers
-
It's Tuesday and I'm not sure what you're asking 😂
Can you elaborate? Maybe share some screenshots on what you're trying to accomplish?
I think what you're saying is:
If ColumnA row1 is "Apples", and Column B through D are Oranges, Grapes, and Lemons, then on any row with Column B through D = Oranges, Grapes, and Lemons, set ColumnA to "Apples." Is that right?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!
