-
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…
-
Merged: Formatting Capabilities in Automation Emails
This discussion has been merged.
-
What do I do if my automations keep failing?
Good afternoon, We are trying to have data moved from one sheet to another every month using automations but we are running into the issue that once the sheet gets too big (too many rows) the automation will fail to move specific rows out. I am looking for a solution for this issue and an alternative to manually copying…
-
How to set a notification reminder when a due date is coming up?
I am trying to set up a sheet so that every time a due date is coming up, they get a notification the week before. I have attached a test automation sheet that I have set up, as well as the automation, but I received no email.
-
Linking new entries to previous entries - tracking attendance
I'm trying to create an easier/faster way to track attendance at the multi-week classes that our health educators teach. Currently, they have to enter in static information every time they complete our outreach tool (like, address, timing etc) and I am trying to make it so that they only have to enter that information one…
-
Need formula & function for the question below
If I apply for PTO, I want to make sure it's getting subtracted from the "WR Balance Before Application" and it would be straight subtraction selecting cells & it's sorted. The main formula I am looking for is, If I apply again, my "WR Balance Before Application" should be the latest "WR Balance Left After Application"…
-
Send From Triggering User - not working
Hi, I have an automation set to "send from triggering user" for when any cell is added / changed that links to a sheet . I am the sheet owner . If a person called John Doe fills in the mentioned form from his logged in Smartsheet account , theoretically the automation should kick in, send out and notification email to the…
-
Report Automations Remove Link to Sheets
Hi, I have an issue and I hope there is a workaround. I have several reports created for different groups of people to view items specific to their needs. Obviously the report is derived from a master sheet. When I send a notification, I send attachments and only attachments. It confuses people when they see the link to…
-
List of automation workflows
Having a list of all the automation worflows on all the sheets, or all the automation someone's name is on could be useful for maintenance. If some employee change responsability, it would be nice to easily find all the automatic workflow that they are involved in.
-
Copy parent row only
I have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., has subtasks under it -- the automation (rightfully) copies the parent row AND its child…