-
Unable to remove user available in a SmartSheed Contacts list
I created a Contacts list column that additionally had 4 people including myself. I then created a record as an example, using my name. Subsequently I deleted my name from the list and changed it to only allow the available people in the list to be selected. Now I do not show up in the column properties list but still show…
-
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…
-
Tier 3 Meetings
Hello, I am currently using One Note to present meeting minutes status to a high-level team regarding, work delay, Non conformance status, if work is on track, what support is needed and impact to other teams. I would like to transition to Smartsheet, but I am not sure of the best sheet to create. Can you help?
-
Merged: Applying Grid View Conditional Formatting in Bulk
This discussion has been merged.
-
Smartsheet Form Displaying Field in Scientific Notation
Hi all- I have a Smartsheet form that prepopulates from a calculated field Tableau. Previously, the primary field was populating just fine, appearing as a plain integer. This field is an integer in Tableau. Suddenly today after this form working just fine for a week, the field is displaying in the form in scientific…
-
Linking two sheets in a very specific way
Hello all! Like my title says, I am trying to link two smartsheets in a very specific way. I have a process in which I have individuals requesting support for specific courses this is tracked in one sheet. I then have a second process that hires people to provide support for those classes. Where I am running into trouble…
-
Automate Status Change Between 2 Sheets
I have two sheets, both with Status columns. Ideally, when the status in sheet B changes, I would like the status in sheet A to change. For example, if my tester (sheet B) changes the status to "Test Failed", I would like my Defect Critical status change to "To Be Reviewed" Can this be done through automation or do I need…