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 ?

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 ?

J. Craig Williams

For a non-Checkbox column, you need to use the IF formula

 

=IF( expression-to-check,  value-if-true,  value-if-false )

 

I could have written the checkbox formula like this:

 

=IF ( [Cash Available]23 < 0 , 1, 0)

 

or even 

 

=IF ( [Cash Available]23 < 0 , 1)

 

(skipping the false-value)

 

Does that get you started?

 

Craig

 

Heshy Tauber

HI Craig , 

 

the last responses if you can help me out how to do a if formula by date 

 

=(if Date we call 4<"Today",0?

 

how does the date formula work and can you give me more information on how to set up the if function with a date questioner ?

J. Craig Williams

Heshy,

 

If the date is hard-coded, then use the DATE(year,month,day) formula to turn it from text/numbers to a date.

 

=IF(DATE(2017,03,27) < TODAY(),1,0)

 

will return 1 if the date is in the past and 0 if it isn't.

 

If you are looking at a value in another cell, you can just point to it

 

=IF([Start Date]23 < TODAY(),1,0)

 

for row 23 and the [Start Date] column,

 

Craig

 

 

 

billing10428

Hi its not Working for me what im i doing wrong 

 

=if([Date To call]4<(TODAY)(),1,0)

J. Craig Williams

TODAY()

 

not

 

(TODAY)()

 

Craig