If cell from a different sheet equals todays date, show content from different sheet

I have a master sheet that has tons of data. I want to pull only data from two columns from a row if the data matches today's date.

I have tried the following:

=IF({sheet A column 1} = TODAY(), {Sheet A column 3}, "")

=INDEX({shhet A column 1}, MATCH(TODAY(), {Sheet A column 3}, '')


These are not working.

Can any one help?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!