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

edited 12/09/19 in Archived 2017 Posts



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
    J. Craig Williams ✭✭✭✭✭✭



    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.



  • 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?




  • 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 ✭✭✭✭✭✭



    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,






  • 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 ✭✭✭✭✭✭








This discussion has been closed.