-
Finding and returning values in a range of cells
Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certain value, and join them together. For example, say I had a row with 4 columns that say…
-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
Re-using Update Request Links
Is there a way to re-use an Update Request link? For example, if I opened an update request and I am not ready to post a response, is there a way to open the Update Request again? The Update Request link is a one-time only link right? Is there a way to work around that? Thank you
-
Automated Update Requests based on 'Assigned To'
Hi I'd like to set up automated update requests to be sent out on a bi-weekly basis with a pre-defined set of fields to be completed in the update form. I don't have a trigger for this, I'd just like people to provide updates to their project, rather than trigger this from a change in a particular field. Any thoughts as to…
-
Overview of (Pending) update requests
As the Owner of many sheets I have to get into every sheet to see if there are still pending update requests. Is there a way to get an overview of every update request. Preferably in the More-section in the left-menu ?
-
Mutiple Contacts / Update Request / Form
Hi All, I have a column that has multiple contacts. I'd like to send an update request or form to each contact in the cell but I don't want one contact to overwrite another contact's information. I want to capture the information from ALL contacts in the cell. Questions: 1) Form or Update Request? 2) Is it possible to have…
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Automated update request not working - Resolved
I set up a form that collects data and defaults a "status" column to 'Request Received. I then set up a an automated update to send an update request to me whenever a new row is added and the status is 'Request Received". Last week when I set this up it worked and I received the email and the alert in Smartsheets that I…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Submitting Forms During Maintenance?
When Smartsheet goes down next Sunday, will we still be able to submit update requests that had been sent out before the scheduled maintenance? I am scared of spending a lot of time filling out a form and having it go nowhere when I press submit. Asking about update requests specifically. Thank you