Currently, Smartsheet automation allows actions such as sending alerts, updating cell values, moving rows, and requesting approvals. However, there is no option to automatically add a comment to a row or cell when certain conditions are met.
Use Case:
- When a status changes to “Needs Review,” automatically add a comment like “Please review this row for accuracy.”
- When a due date is missed, insert a comment indicating the delay reason or next steps.
Benefits:
- Improves collaboration by providing context directly in the sheet without manual intervention.
- Reduces repetitive tasks for project managers and teams.
- Keeps communication centralized within Smartsheet instead of relying on external notifications.
Suggested Implementation:
- Add “Add Comment” as an action in the Automation Rules panel.
- Allow dynamic text in comments using column values (e.g., “Task [Task Name] requires attention.”).
