Nested Index/Match if Partial Text
I require a cross-sheet formula that will search for a Task (row) in another smartsheet, if the Task ‘Comment’ (column) contains the word “All”, then go to another Task row and index the Date. If the Task ‘Comment’ (column) does not include the word “All”, display the original Task Date.
If Task 4 Comment contains “All” (upper or lower case) within the text string, then display the date for Task 9 = 12/18/21
If Task 4 Comment does not contain the word “All” (upper or lower case) within the text string, then display the date for Task 4 = 12/27/21
Any ideas on how to make it work? Thanks for your help!!!
Help Article Resources
Check out the Formula Handbook template!