I need assistance with filters. Trying to have it select the day and date withouth the year. To send an automated email to the user on the spreadsheet by firstname and last name using the email address column. Finally I would like it to populate the last sent column but I am unable to set the correct filter on Google Sheeet in my scenario. Can someone help?
Hey there,
change it to Text Operator Contains and have it match this one:
{{formatDate(now; "M/DD")}}
I attempted to use the query {{formatDate(now; “M/DD”)}} that you stated and still getting error messages. I also attempte to use this on and still receives error messges TEXT(Birthdate, “MM-DD”) = TEXT(TODAY(), “MM-DD”) Please see screenshots. I really appreciate all of your help on this. Stoyan would you be willing to help me out for a fee if needed?
Welcome to the Make community!
Please use the Hire a Pro category to request for private 1-to-1 assistance via video call/screenshare/private messaging/etc. This may help you get your issue resolved faster especially if it is urgent or contain sensitive information. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services in other categories like here (even if it’s free/unpaid). Posting in the Hire a Pro category will allow other members to assist you over other forms of communication.
Alternatively, you can use the private messaging feature to directly reach out to other forum members. To do this, go to your profile, and click on the “New Message” button:
Hope this helps! Let me know if there are any further questions or issues.
— @samliew