Try this for an alternative in google sheets: Reminder System | Google Sheets | Conditional Formatting | Apps Script | Email Notification th-cam.com/video/UZ9112PoBMQ/w-d-xo.html
While the video was quite helpful, the title of the clip is somewhat misleading. I was searching for a solution to notify (as in e-mail notification) when something's changed, all other results were topical except this one. Keep it up, though! Cheers
Try this for an alternative in google sheets Reminder System | Google Sheets | Conditional Formatting | Apps Script | Email Notification th-cam.com/video/UZ9112PoBMQ/w-d-xo.html
Can i set rules for columns for example every 90 days my gas detector needs calibrating. So 2 weeks out the columns would go yellow then the date it's due and beyond it's red?
how to make this reminder recurrent every X amount of days, like for example every 25 days i want this to show the orange color for one whole day for example. Thank you
I found this useful, may can relate: Create an Event Reminder use Color | Status: Finish; Today; Three Days Until 1 Day Before Event th-cam.com/video/7FdByf2TEo0/w-d-xo.html
IDK why but all these formulas never work on my work pc very frustrating. always the same error: There is a problem with this formula, not trying to type a formula? etc...
Where are the reminders and Notifications? Is there a way to get Excel to give notifications and reminders without having to manually open Excel? Notify me so I can open Excel and see what is in alarm
Notification and Highlight are different things!
I know right! The title is misleading
Absolutely
It's that way because Excel doesn't have a way to send actual notifications sadly. This was helpful for me, but it's not ideal.
Can this be setup to send a email or text message reminder for the date range?
It is a really useful thing for you to create notifications and reminders in Excel! Thank you!
This is great! How would we modify the formula if we wanted a reminder that would last 2 whole weeks before the Due Date?
Try this for an alternative in google sheets:
Reminder System | Google Sheets | Conditional Formatting | Apps Script | Email Notification
th-cam.com/video/UZ9112PoBMQ/w-d-xo.html
Is there any way of creating a kind of separate "summary" sheet to show lets say expired and expiring in
Hi, have you figured out a way for this yet? I'm looking, but haven't found an answer
I know u just need a filter
U need to filter
The older I get the more I feel the need for this reminder feature, thanks a million.
Hi, Are you able to make reminders only counts business days? For Office 365 for MAC
While the video was quite helpful, the title of the clip is somewhat misleading. I was searching for a solution to notify (as in e-mail notification) when something's changed, all other results were topical except this one.
Keep it up, though! Cheers
@Himanshu Jha Hi guys, Please let me know if you find something that notifies with an alert! Thanks
Try this for an alternative in google sheets
Reminder System | Google Sheets | Conditional Formatting | Apps Script | Email Notification
th-cam.com/video/UZ9112PoBMQ/w-d-xo.html
Can i set rules for columns for example every 90 days my gas detector needs calibrating. So 2 weeks out the columns would go yellow then the date it's due and beyond it's red?
how to make this reminder recurrent every X amount of days, like for example every 25 days i want this to show the orange color for one whole day for example. Thank you
Thanks for the helpful info bro.
How do it for the whole column?
Please help me, i want to set up a program to ensure me that i can see every day when a driver licence or pdp expired how can i done this in excell
its not working in my side . i enter the formula but keep getting an error message which doesn't recognize it as a formula
THANKS, IT IS REALLY HELPFULL
How do I make my conditional formatting for the due date and anything past it? and copy that to all cells below?
Thanks for saving me
i want my execl reminds me the due date via whatsapp notification is it possible ??
Well explained
I am trying to do this, but need to set it for a year and, 3 yrs, etc.
How do I make it to show past due dates highlighted? What would that formula be?
It should be the same as the last formula, but istead of +4, it should be -4
Doesnt work form me keeps poping out msg an keeps askig if I am trying to write ruel and suggesting to start with apostrophe......
instead of using a comma to apply the second logical use this ;
Great Tips! Thanks!!
It doesn't work. I've gone through this video numerous times now and nothing changes. What am I missing?
I found this useful, may can relate: Create an Event Reminder use Color | Status: Finish; Today; Three Days Until 1 Day Before Event th-cam.com/video/7FdByf2TEo0/w-d-xo.html
how about i need to notify a month before sir? thank you
in the second formulation, you could adjust the date you desired by replace '4' to your prefer date
IDK why but all these formulas never work on my work pc very frustrating. always the same error: There is a problem with this formula, not trying to type a formula? etc...
Sir how about if I want how many staff has expired certificates?
If you find the answer, could you share? That is exactly what I need to do as well.
@@NOREFABY I know the answer
how do i apply this rule to an entire column
click the cell > hold ctrl + drag the cell downwards until whichever cell you want to apply the rule.
where is the link to copy the code for POP-UP?
Perfect. Thank you for showing this very simple to follow how to video
You didn't mention about the alert message formula
hi is it possible to add a sound notification
Awesome and very helpful video. Could you do the exact demonstration but for Google Sheets? Can Google Sheets not even have color coated "reminders"?
Thanks for the idea!
Google sheet i try not work, do u ?
i need desktop notification with excel. is this possible?
Please help it is not working
thnx really helped
The window of "new formatting rule" is very small in the video,I couldn't see what you are writing..
I found this useful th-cam.com/video/7FdByf2TEo0/w-d-xo.html
I tried it but its not showing any results
Great job thank you 🙏
Where are the reminders and Notifications? Is there a way to get Excel to give notifications and reminders without having to manually open Excel? Notify me so I can open Excel and see what is in alarm
Today is 6/26
Yeah we're on the same day but a year later 😄
nice video man
How to connect phone reminder to excel
it is not a reminder or notifications
This is the real one: Reminder via email from your Google Sheets data th-cam.com/video/UZ9112PoBMQ/w-d-xo.html
This trick was saving my day, thank you
:)
This formula not working
Picture is so small
Thank you, we get that.
This does not do Notifications or Reminders! This is just highlighting cells!
Hi buddy
Such a misleading title. Highlighting is different than sending notification!
You wasted my time with your misleading title. Absolute waste!
Just wasted my four min and 36 sec