-
Column Formula Not Filling All Rows
I have a column formula that isn't filling all rows. I have a row id with auto numbering and it's only going to 4 rows. I need it to fill in the whole sheet so that my index match formulas can look up if another row is created in another sheet. I'd like to get the auto numbering column to continue filling in the rows for…
-
Drag and Drop or Move Summary Sheet Fields
Is there another way to move fields other than just the move up or down with one increments?
-
Anyway we can automate SmartSheet to remove / delete rows.
I have a dump sheet that needs to be clear every day. Move row does not work, its adds another step into a simple task.
-
Please tell Smartsheet to improve Contact column contact population/handling!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
What formula would I use to read a date from another sheet?
I have a sheet that collects dates in a column "CO Internal Target", I want to be able to list that date on another sheet with a formula. It should be able to read the "Studio Code". Both of the columns are on both sheets. The sheet that I am wanting to read from is the "Location Tracker - SS", the sheet that it is going…
-
Metric sheets: using rows or using columns
I have set up a number of metric sheets using rows and columns to set out the data. Whilst the two approaches work separately and can work together in the same sheet has anyone developed any rules or principles about how to set up a metric sheet. I'm particularly interested where the sheet requires that you add new sheet…
-
Smartsheet API in Python: Inaccessible 429 Response
I am trying to understand / plan for the rate limits, particularly for the get_cell_history method in the python api. When I run the code below, I see the following response printed to my console: {"response": {"statusCode": 429, "reason": "Too Many Requests", "content": {"errorCode": 4003, "message": "Rate limit…
-
Sheet Access Request - Provide more information in request
As the Owner of the majority of the Workspaces in our company, I often receive the email from an external party, requesting access to a particular sheet(s). Whilst I may be the Owner, I am not typically the manager of the project and have little insight into what role that external party plays. On receipt of these…
-
Link Reference Sheet Dropdown
Is it possible to reference a list on a separate sheet for the user to select as they input data into rows?For example; activity type, client name? I have created a time sheet and would like users to reference the data in another sheet. Thank you, Rachel
