-
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?
-
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.
-
Merged: 500-row limitation
This discussion has been merged.
-
Row Limit Change
Hi SmartSheet, Did a release happen recently that expanded the number of rows allowed in a sheet past the 20,000 limit? If so, what is the new limit? Is there a communication that went out about it? I know this is on a RoadMap but have seen any updates on it.
-
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.
-
Merged: SCC Global Update for adding a new row with "task information" to a Project Plan
This discussion has been merged.
-
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:…
