I'm using an INDEX(COLLECT()) function to pull data from cross sheet reference; however, is there a way to pull partial data from the reference cell? For example, the reference cell is "Molecular Divi…
Hello, everyone. We've been working with support but I wanted to get a feel on what other users are finding. Does anyone else find inconsistencies in their Data Shuttle updates? It's been suggested to…
I have a column in my sheet that allows multi-select in a drop down. I want to create a filter that will show me all the rows that have multiple values selected in that column, how can I create a filt…
Hi, I'm in the process of setting up a system for gathering approvals and I'm curious to know if the approval link included in the automated email has a set expiration date or if approvers have the fl…
Hello Everyone! I am creating an automation and am aware that an image cannot be included in the body of an automation email. However, I opted to have the image attached to the workflow email by inclu…
My sheet has multiple approvers who vary by the row depending on certain criteria. I want to send them all the row approval request at the same time, then when they all click approve the project can m…
I want a date to populate a field that will trigger a follow-up workflow. My criteria is: If the certification Complete is GREEN, this date can remain blank, as no follow-up will be sent. If the certi…
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 approv…
I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week…
I have multiple sheets following a complex workflow. When some of my workflows are completed and moved to the next step in the process, I want the row of information on a sheet to be automatically hid…
