-
Change Cell Value Automation - flag or symbols
I am wondering why you cannot set the value of a flag or symbol using the Cell Change Value Automation? I cannot see how to do it. I have a flag column that I want to let the users manually set to highlight what needs to be looked at and also have the flag set automatically when certain conditions are met. I can't use a…
-
Teams Automation
Hello Community, I am trying to work a TEAMS automation for notifications in TEAMS channels. However when getting to the part to select the public teams group is it not giving me all of my public teams in TEAMS to choose from. Is this a SMARTSHEET issue or an internal IT issue? Thank you!
-
Automation to find exact word match in a text field
I'm exploring a way to precisely match the word "HE" within a text field used for comments. When the exact word "HE" appears in the text, I want to populate another field named "Gender" with the value "Male." However, I'm encountering a challenge where the search for "HE" also matches it within other words like "SHEET" or…
-
Change drop-down option in one cell based on data entered in a different cell
I am looking for a way to automatically select a drop-down option in one cell based on the data entered into a different cell. Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine…
-
Update requests - Send 1 update request for multiple rows to the contact that is listed in sheet
Hi everyone, Here is my issue. I have a sheet of sales people that are from multiple different companies that tracks their YTD sales numbers. I want to build an automation/workflow that sends one update request with a form to update ALL of that contact's producer with one click. So if one of my partners has 10 sales people…
-
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…
-
Workflows - Streamlining Multiple Change Paths
I recently learned that I could have multiple change paths, and I was thrilled, no longer duplicating and changing for each criteria! But I am stuck on this one. Below is one of many workflows. The user will enter the Workstream (Train and Resources), and then the PM field will assign a person. I want multiple conditions…
-
Life of a Ticket
Hello friends! I am creating a log which tracks the life of tickets we open. When we change the assignment group or status of the ticket, I would like for a new row to be automatically be created, preferably a child row so I can somehow only count parent rows hopefully in totals. Is this possible? Either of these :) Thank…
-
How to create a formula that will send notifications to specific users
Hello, Im trying to create a column formula that when a user selects a certain field, the responses will automatically go to a specific person/responder and will notify them of a task that's awaiting their approval. For example: someone wants more information about a specific oncology drug, (the "therapeutic area" column).…
-
Change cell automation not working
I have an automation to change the value of one cell based on the value in another cell in the same sheet. The change is to occur when triggered. The source cell value is based on a VLOOKUP formula referencing another sheet. The cell with the VLOOKUP value changes based on the formula, but the automation to trigger a…
