-
Is there a way to optimize drop down menus?
hello i am trying to have certain values only show when someone chooses one value. here's an example: Entity 1 Entity 2 Entity 3 Now based on those three entity there would be a seperate drop down menu with 10 items: Item 1 item 2 item 3 item 4 Ext... But if i choose entity 1 then only item 2 and 7 show but if i choose…
-
Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible. I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet if…
-
Can a Workflow Cancel a Remaining Requests for Update if 1 of 3 people update?
I have a use case where we dont want to use request for approval because it writes an additional column to the sheet, we are currently using Request for Update to utilize the row form to assign a project task. When a row is created, it sends a request for update to assign a task to three people. Once one person completes…
-
Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?
-
Automated Alert with all row attachments
Hi, My automated alert is triggered when rows are added or changed and a specific condition is met. A change would be when an attachment is made. There will be several attachments to a row. However, it appears that the alert only includes the latest attachment(s) that triggered the workflow. How do I get the alert to…
-
Data Shuttle is duplicating data
I have a smartsheet that is pulling data via Data Shuttle from a Google Sheet (the GS is populated with data from an Alteryx report every hour). Data Shuttle is set to update and add new data. Each line of data in the GS is assigned a unique number and that data is pulled into smartsheet based on the unique number.…
-
Add Increment/Decrement to Automation Change Cell Value
Sometimes, it would be helpful to have a means of keeping track of a count related to automation. For example, if I keep sending a reminder email on a regular basis, I would like to have a cell that counts how many times it gets sent. It would be easy to do if Change Cell Value had this an option.
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
Help Needed: Workflow not triggering
Hello! I am new to Smartsheet as of last month. I found a website showing me how to send a notification when a predecessor's status is setup to "Complete": https://www.ignatiuz.com/blog/smartsheet/notifying-a-task-owner-when-predecessor-gets-completed-in-smartsheet/ Here is my setup: Row ID Column: Predecessor Copy Column:…
-
Automation 'Send to....'
Hello, I know I can send to a specific cell reference and I also know I can send to a specific user. But can I send to a specific cell reference on a different sheet? The reason is I have a sheet that has a number of team members that are required to accomplish tasks, but the PM lives on a "Teams" sheet and I would like to…
