-
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
-
Is it possible to copy an automation workflow from one sheet to another sheet?
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need to manually set up the workflow on my new sheet. Thanks!
-
Auto Delete rows
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
-
Memorializing cell content
I have a column that calculates a date based on 'Column XYZ - 127'. This works perfectly. However, if 'Column XYZ' changes then my destination column will also change (obviously). But I want to preserve what the date WAS before it got changed. So I thought to insert a 'Helper' column and copy the date from destination to…
-
Date stamp does not trigger when Health changes in cell for a referenced value from another sheet
Hi all, I've followed the article Set the current date with the Record a Date action | Smartsheet Learning Center and was unable to get a date stamp to populate in a cell when a project's Health changes. Essentially we have a Project Rollup sheet which lists all our projects provisioned via SCC and the health values are…
-
Can you group columns?
I have a very large Smartsheet that contains contact info, partners, dates for various deliverables, financials, etc. I'm wondering if there is a way to group columns that reference similar tasks thereby make moving around the sheet a little more efficient? For example there are 14 columns that pertain to permitting, 5…
-
Any progress on Copy & Paste Columns
desperately need it!
