-
Clear a Sheet on a Schedule
Hello lovely community, I need some help figuring out the best mechanism for clearing a sheet on a schedule. It really should be easier than this! I have tried the following methods, and outlined the limitations and issues below. I would LOVE to get some suggestions for other methods! Problem: I need to fully clear (delete…
-
Can index+match be used to add values together?
I'm in the process of creating a series of sheets to track weights submitted by a variety of people. The people are going to be categorized by 'team', and I already have an index+match formula that takes their submissions and automatically organizes them to like a main row per person, each value going into the column for…
-
Issues with Automations on Calculated Fields
I have a task tracker for our team that I want to auto-archive tasks 5 days after they are complete. I built a checkbox column that compares the completed date to todays date (using a reference rather than TODAY() formula so the formula works when I'm not in the sheet) and if it's been 5 days it checks the box - which in…
-
Autofill Form
So if I have a purchase request form I want to select Item A, for example Once I select that, I want it to give me than a list of budget numbers to pull it out of (Item A for engineering, Item A for software, etc.) Then autofill with a set price, and I put how many I need and/or show me how many are currently budgeted for…
-
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.…
