-
Unable to access Core App Skills Capstone Exercise assets – “unspecified error”
Hello, I am currently taking the Core App Skills eLearning Capstone. When I tried to start the Capstone Exercise, I was instructed to download the exercise assets from Smartsheet.com. However, when I attempt to access via link, I get the following error message: "unable to copy the specified sheet(s) due to an unspecified…
-
INDEX COLLECT give #INVALID VALUE error but INDEX MATCH does not
INDEX COLLECT gives me an #INVALID VALUE error =INDEX(COLLECT({event-25}, {date-25}, Day@row , {ID-25}, [Employee ID]@row ), 1) ========= But using the same reference for INDEX MATCH does not =INDEX({event-25}, MATCH(Day@row , {date-25}, 0)) or this =INDEX({event-25}, MATCH([Employee ID]@row , {id-25}, 0)) ========= I need…
-
What are the limits using Table View
I'm having an issue with Table View in that a sheet with 498,000 cells will not add a new column into the sheet. Theoretically, this will push the sheet to about 510,000 cells. I was under the impression that Table View has a capacity of 1M cells. What are the actual upper limits for Table View, columns, rows and total…
-
Best way to pull data from different columns into one
I have a worksheet that is populated via a form. Worksheet is currently 300+ columns wide (I didn't build it, I inherited it). The form is used by facility management technicians. Each time they go to a client site to service facilities, HVAC units, refrigeration units, etc. they complete this form. Yes, they complete in…
-
Having Issues With "All Contacts" Via Send Function
Hello community, I have users that frequently use the Send function in both Calendar and Grid View to send to contacts, note, there is no Contact column in this sheet. These are simply recipients of the Send function. The issue they are having is that old email addresses they've used previously won't leave the "All…
-
Table view initial release is now generally available for all customers!
Hi Smartsheet Community members, You’ve asked for faster sheets that can handle more data so you can manage large-scale projects and programs. You’ve asked for real-time updates without the need to save or refresh so that you can collaborate on work effectively and confidently. You’ve asked for a more intuitive and…
-
Search Adjacent Row
I want a formula in a cell that searches the adjacent cell with its drop downs and then it would populate with my other referenced quantity cells elsewhere. Cell is UNIT that I select from a drop down list: S.F. Bldg., Weeks, Months, Other I want this formula in my cell at adjacent row of REF. QTY. to read cell UNIT and go…
-
Dashboard Chart
How do I change the values on the vertical axis?
-
Bug with dates and filters?
I have a filter that shows items meeting certain conditions and not created within the last 7 days. We are in UTC+4. Yesterday, the filter included an item that had been created after 9 p.m. the night before. Today, that item was properly excluded by the filter. Am I missing something, or is this a bug? Does anyone know if…
-
Data Table Usability: replace all data
The current limitation using Data Table but not being able to replace all data when using Data Shuttle makes Data Table very messy with Data that should not be there any longer. There is also no easy way to remove ALL entries to refresh Data Table (Currently only 100 lines per deletion) , It was also Suggested in the TT I…