-
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…
-
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…
-
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…