Notifications or Reminders

billing10428

Hi,

Is their a way to set auto Notfcations when a cell is a nagtitive number

my example on a sheet is

if Payments to A/P (A/P is payments made to Vendors in that month)

in Box A/R Payments Recevied (in AR Box i have monthly Income Recevied to Date)

Net Cashflow =Ar -AP = Cashflow Available if the amount is in a minues i want to get a notfication ?

Find more posts tagged with

Email Notifications

Comments

J. Craig Williams

billing,

Notifications are setup on changes, not on critieria.

That said, you can set up another column to check if Cash Available is less than 0

In a check box column, this will be checked for negative values

=[Cash Available]23 < 0

for row 23.

Set you Notification when that column changes.

Note that you will also get an email if the value goes from negative to non-negative, but that is a small price to pay, IMO.

Craig

billing10428

thank you that sounds great but How dose this Check box Formuila Work

=[Cash Available]23 < 0 if i do that by cash Flow Coulmn it will automaticaly make a check mark if its less then zero ?

billing10428

yes i see amazing Wow Thanks a lot

billing10428

Hi Craig,

is their a way to make the same foumuila by a date

Meanning to say i have Collection sheet i use a date Coulmn

Lets say i have to call back a customer for moneey 03/07/2017
ill type in their the date 03/07/2017 i need to call the customer

i have auto Reminder set up that anyware in the sheet where it sees this date it sould send me a notfication on that day to call

but i want it to send me as well on the past due dates notfication just in case i dont get to call? so i was thinking of doign such a change statues from Checkmark but can i set such a foumuila =date to call 23< instead of 0 to have it see if its past date then today ?