-
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…
-
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…
-
Workflow Action to increment a Cell value by some number
As a programmer there are many cases that I would like to take a number in a cell and add some value to it. I dont have a particular use case in mind currently, but this allows another tool in the box for coding complex systems.
-
Time zone discrepancy in Automations
Hello! Something strange has happened - my Smartsheet profile is set up for AZ time zone, and my workflows have followed that. However my Automation workflows switched to Eastern time today, so due to the time difference they all went out incorrectly. How could my Automation workflows run off a different time zone than my…
-
Has anyone seen this issue before with column references inside the message body of an alert?
The template is setup with references to columns in the sheet for notifications. After the project is provisioned through Control Center, the message body is showing {{INVALID COLUMN}} instead of the column name set in the template.. I've never seen this issue before personally. Has anyone seen it?