Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Notifications or Reminders

billing10428
edited 12/09/19 in Archived 2017 Posts

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 ?

Comments

  • J. Craig Williams
    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
    edited 03/07/17

    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 ?

  • yes i see amazing Wow Thanks a lot 

  • 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
    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
    edited 03/29/17

    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
    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
    edited 03/29/17

    Hi its not Working for me what im i doing wrong 

     

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

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    TODAY()

     

    not

     

    (TODAY)()

     

    Craig

This discussion has been closed.