-
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…
-
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…
-
Merge cell functions
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
-
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…..
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
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…
-
Copy and Paste Column's
Need a way to copy and paste columns from one "standard columns" sheet to new sheets. This would be similar to a template but more flexible.
