-
Do Not Email Notify Triggering User from Workflow Automation (PMO)
How can I stop my automations from copying the triggering user via email? The automation itself works great for letting the inteded person know they've had a task row assigned to them via email - but the triggering user does not want to be copied on said notification. I've searched the community for answers - I've been…
-
10 rows Created: Only want one approval notification & response to control all rows
I use an order form and some fancy footwork (learned from these forums) to copy 10 rows of duplicate data for each order to a sheet, all duplicate except for the Item ordered itself. Below is an example of ONE form submission containing 10 items ordered: However, now I need to: Send one approval email request to the…
-
Why does Smartsheet add empty rows to sheets? Can this be disabled?
If I delete empty rows on a sheet, after saving and reloading, Smartsheet will add 10 empty rows to the bottom of the sheet. Example: My 66 rows becomes 76 rows (10 empty). 50 rows becomes 60 rows (10 empty). When I use a "Copy Row" automation, Smartsheet adds enough empty rows to ensure the destination sheet has at least…
-
What formula do I use for my needs?
I have 2 sheets (see screenshots) and what I need is to have the Associate Name from the Associate List sheet copied to a column in the Permissions sheet but only if certain criteria is meet. If there is a date in the Yard Access AND GTDR Expiration columns, I need the Associate name listed in the GTDR Certified column on…
-
Sheet history with deleted rows
When we synchronize a Smartsheet sheet with another application and delete a row, sometimes the row cannot be deleted in the other application due to business rules, and we must restore the row’s data. Additionally, sometimes when a row is deleted, we need to send specific data from a cell, but we no longer have access to…
-
Folders within row attachments
Sometimes a job has many different types of documentation, it would be nice to not have everything all jumbled together just because it pertains to the same row (job). Organization within each Rows attachments.
-
Dynamic View Row Height Formatting of Wrapped Text: Bug? Or How Do I Fix it?
We're moving to the new and "better" User Subscription Model soon. Because free users will no longer be able to modify data in cells, we're trying to create Dynamic Views for all our City's Workspaces where free users need to add/update data. The problem is that the automatic Row Height formatting does not work properly on…
-
Formula Help: Find Value in 1st Row in Same Column, without using Absolute References
I'm trying to create a formula that gives me the value of the first row in the same column. [Find This Value]. There are a few obstacles: The formula is placed in the same column, BELOW value we're trying to find, in [Find This Value]13:[Find This Value]21. So it needs to be a cell formula and not a column formula And my…
-
Attachments
Hello, Is there a way when attachment to the row is opened that this pop-up window to the side DOES NOT open?
-
Need help finding a way to create an enrollment or disenrollment form automatically.
Currently we have a form that adds rows and "dealers" onto a program. I have been having issues finding a way to make that form or a separate form have a way to allow a drop down of the enrolled "dealers" where they can choose and add a reason request for that removal. If it is approved then have that modified row move to…
-
Need formula to show row ID/link in a cell
Hey team, trying to find a way to populate a row id or row link in the cell. Is it possible?
-
INDEX / MATCH and HAS / CONTAINS?
I'm determining how long a person has been parked based on the parking lot zone number and the amount of money paid. I have a separate reference sheet that lays out the zone numbers, location names, and all of the possible amounts someone could have paid in this lot - this is the sheet I'm trying to reference. When I…
-
Copy Row Reminder to Another, or All, Rows
In a project with multiple date columns that function as due dates, you can set up row reminders that correspond to those due date columns. This is in addition to setting up Automated Workflows that can email reminders on due dates. But why would you want to set up row reminders in addition to using the Automation…
-
Automation Saying Cell Limit, but not at limit
I have 62 columns and 7921 rows, meaning I have 491,102 cells, well under the 500K limit. However, I am receiving an error in an automation saying the target sheet has reached its limit. Does anyone know what is causing this?
-
Dynamic View Row Height Adjustment
Dynamic view cuts off my text even though my text is wrapped. Would be great to allow for auto and manual row height adjustments.
-
Copy row to another sheet help
I have a Task Request sheet that has a column listing the name of the Project to which the task belongs. When a new task is created (from a form) and the requestor has selected the Project it belongs to, I would like to create an automation that copies the task row to sheet that has the same Project name. If there's a…
-
Use the internal row id
We manually add the internal rowID to a new row by selecting the row properties, copying and pasting it into a field. Then a URL is calculated to provide a link to that specific row. It would be helpful if there would be a way we could generate a hyperlink but access the rowID directly something like:…
-
How do I automatically copy rows within the SmartSheet to a new row
I have a sheet and I want to copy an existing row of data to a new row of data in the same SmartSheet and change the value on one of the columns when its copied. is this possible?
-
Do not add 10 blank rows at the bottom of the sheet
Please STOP adding blank rows to the bottom of the sheet. They are unnecessary and can cause issues with formulas.
-
Is there a way to set row heights in a sheet back to standard?
I am trying to create a report to add to a dashboard. The sheet I am pulling from previously had several rows expanded due to large comments and the wrap text feature. To pull into my report, and for view of leadership, I would like the rows to be standard for a cleaner feature. Any ideas?