Today / Yesterday formulas
I need to create a dashboard to include all calls made to clients, either today or yesterday (the idea being that the charts would change on a daily basis). My issue is that I don't think I can use the Today or Today -1 type formulas as the date column is NOT a date column type, but a text column type. I can't change it to a date column as it is auto populated using an API link from another site, so I cant change this as it will mess us the API link.
All dates are in the same format: Monday, October 19, 2020
Can anyone help with what formula I could use, or is this not possible?
Thanks in advance 😀
Help Article Resources
Check out the Formula Handbook template!