Wildcard Workaround

Options

Hello! I'm trying to achieve a formula that would usually use wildcards. So in Sheet 1, I have three columns, Meeting, Date, and Time. In the first row of the Meeting column, I have the following data: Topic 1 - Tuesday, October 17 @ 10am - 10:30am. The Date and Time columns are blank for now. In Sheet 2, I have three columns, Topic, Date, and Time. In the first row I have Topic 1 under Topic, Tuesday, October 17 under Date, and 10am - 10:30am under Time. Now here is what I'm trying to do:

On Sheet 1, I want to build a formula on the first row under the Date column that finds Topic 1 from the meeting column in Sheet 1 in the Topic column of Sheet 2 and pulls the Date field over from Sheet 2 into Sheet 1. Again, it's not an exact match of data since the meeting column in Sheet 1 says "Topic 1 - Tuesday, October 17 @ 10am - 10:30am" and the Topic column in Sheet 2 says "Topic 1" Can you please help???

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!