Hi everyone! I have a list of report dates that I want to be notified on, but am having trouble getting this set up.
My thought process was to create a column with =TODAY() in the first cell, and then set up automations to be alerted when "Today" equals the "Report Date".
My issue is that two are different formats. The Report Date column is formatted as text (this is due to a connection with another sheet and multiple dashboards so I do not want to adjust the format of this column; it needs to have the leading 0 to be connected to the other sheet).
Instead, I tried adding helper columns ("Report Date as Date Format" in the screenshot below) to convert the Report Date from Text to Date. Even though they look the same, they are not returning as "Yes" in the "Equal" column. (That column is formatted as: = IF([Today]$1 = [Report Date as Date Format]@row, "Yes", "No").
I also tried the opposite — converting the Today date to text in the "Test as Text" column using:
=INDEX(Today:Today, 1) + "" and that still did not return a match.
Does anyone have any ideas on how to connect the two (without manually having to write the Report Dates in a different column as dates)? Or a different idea altogether in how to be alerted on the dates listed?
Thank you!
