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
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
-
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
-
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 ? -
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
-
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 ?
-
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
-
Hi its not Working for me what im i doing wrong
=if([Date To call]4<(TODAY)(),1,0)
-
TODAY()
not
(TODAY)()
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives