-
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…
-
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…
-
Seeking Automation Solution for Linking Cells from Multiple Sheets to Master Sheet in Smartsheet
I'm looking for a way to streamline the process of linking cells from different sheets to a master sheet in Smartsheet. The master sheet, 'Project Dashboard,' contains 15 columns where linked cells need to be added. Each project has a unique 'Project Plan' sheet with identical formats but different dates. How can I…
-
Separate reply-to email address for auto emails
Hello, I'd like to vote for the feature of a separate reply-to email address when setting up auto emails. I'm the owner of a large number of sheets, and despite it not necessarily being a problem that emails appear to come from me, i'm having a huge issue with the large number of replies i receive. Despite adding text in…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
How do I get the Move and/or Copy Automation to work properly?
This automation with work for a short period then stop and show me this error. Of course there is going to be a matching a matching column. How do I avoid it?
-
Record a Date when status changes
I have a set list of statuses that I want to keep track of and collect durations. For example, when the status changes to Sent to Lab (Ongoing), I want it to record a date in the Sent to Lab column. I feel like it should be an easy thing to do I just can't get it right.
-
Automation to change a cell value
Hello - I am trying to use an automation to change a cell value. I was originally triggering the change with a cell populated by a formula pointing to a cell with a cell link from another sheet, which I understand won't work. Is there a workaround for this? More detail: I am using smartsheet for headcount tracking in my…
-
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…
-
Smartsheet Automation
Hi, I have an automation that moves rows once a checkbox is checked off. However, on some sheets, even though it is checked off, the row stays on the sheet. I need to uncheck, save, and then check off again. Any solutions for this?