-
Need a better Sheet Summary Formula - (Collect/Max & Index/Match)
In my example, I am able to return the top Sales for an item based on certain criteria for a Sheet Summary formula (Shirt Top Sales) with =MAX(COLLECT(Sales:Sales, Product:Product, "Shirt")). I am also able to return the Color for the Top selling Shirt (Blue) with a formula using the previous summary value in the formula:…
-
Why is sheet adding rows from dropdown list?
Hi, My sheet is adding in new rows based on my list of dropdown selections. I added in some suppliers in a column which we may use in the future but currently do not have rows in my sheet. However, the sheet is bringing them in as new rows with that supplier name even though I am not asking it to do anything. Do you know…
-
iOS App - COPY Rows
In the iOS app, you can cut and paste a row, but you can't copy and paste. Not sure why this is. Having the ability to copy and paste rows would be extremely useful when working on the go and data needs to be duplicated.
-
Why can't I access the workflow automations on a sheet that was shared to me?
The sheet owner already made me an admin yet I still couldn't open the workflow automations tab (I can access the forms, edit the columns, rows, cells, and etc.) I have good network connection and I already tried refreshing the tab several times. They even removed me then added me again multiple time but the same message…
-
Modified system column questions
Does Conditional Formatting trigger the Modified time stamp? I have a sheet that I want to highlight entire rows to a certain color if the Modified date was in the last 30 days, but every time I save the sheet the modified date would update to whenever I "saved". This is really a terrible design if it does. Also, it looks…
-
Allow Screenshots to be posted into forms and update requests
It would be great if we could add screenshots when submitting a form or Update request, this would be really useful for things like surveys where a product was bought or for maintenance tickets being raised, et…..
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
Dashboard Sheet name Hyperlink proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…
-
Sheet Relationship Diagram
Is there a report I can create that will identify and map out all of the sheets that are linked to other sheets? We have hundreds of sheets, and quite a few workspaces. We regularly link one sheet to another so they all stay updated, but it can be hard to capture where everything is linked. For example, we have a resources…
-
Archiving Sheets with Different Primary Columns
My workspace has 3 main source sheets. Each of these source sheets currently uses a different column for the primary column (two use ID Number, one uses Name since ID number is assigned later) but both columns exist in all sheets. When a request (1 row = 1 request; form intake) is marked completed it moves to its…