Hi Smartsheet Community
I’ve reviewed the Smartsheet library and user feedback, but I’m still unable to build a simple notification based on the content of a single cell. Everything I’ve tried so far only allows notifications based on entire rows or sheets, which doesn’t meet my needs.
Use Case:
I want Smartsheet to send me a notification when the cell in the "% Complete" column of Row 1 reaches 100%. Once this specific condition is met, I’d like to receive an alert or email notification.
Currently, I don’t see an option to target a single cell. Instead, the system returns all rows that meet the 100% criteria, which isn’t accurate for this use case.
Any thought? 🤔
Let me also add that the Smartsheet is used for project management to track multiple tasks.
