-
Add specific text to a row, if a condition is met in another column in the same row?
Hello, I would like to have Smart Sheet add the words "Bad Index" in the status column if index column is "647373". I can use conditional formatting to highlight the row, but when I try to use an automation trigger the whole column displays "Bad Index". This is my workflow. When I run the automation it marks the entire…
-
Trigger "when rows are added or changed" doesn't work
Hello all, I have created a Workflow to send a weekly email notification when rows are added or changed in a Sheet, but it doesn't work with "Run Now". It doesn't detect any of the changes made. I have created this Workflow on other Workspaces and it works fine. If you have any idea, why in this case it is not working, do…
-
What would be causing only some individual to not receive automation emails?
I have a simple automation set up to email a reminder to people listed in a contact list cell. When the automation runs, I get the email, others get the email, but one (possibly more) individual does not. This individual gets emails from other automations running in the company. The automation does show up in their…
-
Multiple Automated Workflows Triggering for same item
Hi! I have helped design a Smartsheet that we are using to track requests. There are three scenarios that we need to capture, and each scenario has a slightly different workflow because certain approvals are or are not required along the way. I am running into an issue when the request is declined, all of my workflows are…
-
how to alert contacts in the row when the Planned date is about to reach?
What process should we use to automatically alert the contacts in that row about the status 3 days before the PP planned date?
-
Turn All Automations Off or On
Sometimes i would like to implement changes to a sheet that would trigger automations that i don't want being sent out. One such sheet has several dozen automations. Turning them all off, implementing my change, and turning all the automations back on, could be a faster process.
-
Hello - looking for help creating my sign in and out form.
I am fairly new (yet familiar with the possibilities available) in Smartsheet. I am in the process of creating a tracking form for my job to see anytime a device is in use and which employee is in possession of a shared device and what location they are working at that moment. I am collecting the employee's name and ID…
-
Frustrated
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
-
Automate Update Requests
Hello, I am trying to implement an update process for our Staff Forecast Tracking Data Input sheet. For each project (grey rows), I would like to assign someone to update all the project staff's LOEs on a monthly basis. For example, an update request would go out to a specific staff member to update the 4/24 column of LOEs…
-
How do I share specific rows only?
I want the user to see rows that are assigned to them only.
