-
Distributing Savings Across Months Based on Term Date and Fiscal Year
Hello My Super Intelligent Smartsheet Community! I have attempted to solve my problem by breaking it up into pieces and I'm stuck. I think I've been trying to solve this for too long and my creative juices are fried. I have Service Providers we have contracts with. Each contract has a Contract Start and End Date and our…
-
Alert Someone Automation Error
Hi all, I have the following alert automation triggering off a date column, however since I added the "otherwise" it always sends two notification emails at the same time as if both conditions are being met. I played around and even when all dates in the column are in the next 7 days, to meet this first condition, it is…
-
Resource Planning: Calculating Weekly Hours Remaining for a Project
Hello, Goal: To view estimated hours per resource per week. I am looking for a way to calculate the weekly hours remaining on a project, per person. I am referencing my project plan as the source sheet which has: Resource Name, Estimated Hours, Start Date, Due Date, Week Start, Task Name, etc. In a summary sheet, I would…
-
INVALID COLUMN error in "Alert Someone" Automation
Our team uses template project folders to easily create each projects schedule and trackers. We use the "Save as New" functionality attaching all reports to the newly created folders. Recently, after saving as new we are getting this "Unable to Run" notification for the automated notifications within our schedule. When…
-
Notification Automation Not Working
Hello Community! I have an automation set up to notify when the first box (documentacion) is selected to send to one group and two set up so that when all paperwork is checked it sends to two separate groups. My automation is not working when i have similar setups in many other sheets. when i force it to run by right…
-
Proof Linking automated notification
Within our proofing system we have a couple automated notifications to remind approvers that they need to approve or comment on a proof at several day intervals. When the initial proof is sent with an invitation for a user to approve, they are provided with a link that takes them directly to the proof. However when the…
-
How do I set SmartSheet to include attachments on the emails that it sends from automation?
Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up? When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an attachment. Currently my trigger for the workflow is when the data in a certain field…
-
Very certified professional, looking for a Contractor.
I am writing to express my enthusiastic interest in a Smartsheet Developer position. As a highly skilled developer with expertise in web and application development using Flutter, I am confident in my ability to contribute effectively to your team. My strong capabilities in database integration and a comprehensive…
-
Merged: Rich Text Formatting in Workflow Emails
This discussion has been merged.
-
Workflow action to set a date to a relative date or static date
I am requesting a formula that would allow me to update a date with something other than today which is done with "record a date". I may want to record 3 days in the future or possibly a fixed date such as "12/25/2026". This would allow me to set fields that can be used for alerts while leaving them editable since they…