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
Hi Guys,
Im trying to set auto Notfication
I have a Project sheet with Date type of coulmn called "Last Updated"
I have another text Column Called balance Due
I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column
and if not do able with smartsheets is Their any other way to set up such a notification ?
Comments
-
Hello,
We don't currently have the functionality to send a conditional reminder like we would for notifications. But you can submit an enhancement request for this functionality here so it can be considered by our development team for future implementations.
A workaround for this will be to :
- Create a new date column. I will call it reminder date for this example
- Insert an IF function in the first cell if that column that will return the last updated date + 2 days when the balance due is higher than 0.00 like this: =IF([Balance Due]1 > "0.00", "[Last Updated]1+2").
- You can drag from the lower-right corner of a selected cell to copy the formula across contiguous cells in the column. As you copy, the formula will automatically change its respective cell references. Learn more about copying and pasting formulas here: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet#dragfill
- Then set up the notification to be sent when the reminder date is not blank like in the screenshot below
Doing this will send a notification when the reminder date is populated. And the reminder date will only be populated when the balance due is > than 0.00
I hope this helps.
Kind Regards,
Pam
Smartsheet Technical Support Specialist
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives