Sheets
Discussion List
- I am looking for guidance for the utilization of the VLookup formula. I have formatted this formula within one of my Smartsheet sheets and I keep getting the #No Match error message, I have verified t…
- I maintain master lists of initiatives in one sheet for each program I'm tracking but not managing. When conducting reviews, I filter the list of initiatives based the stakeholders I am meeting with. …
- Okay, I have a three-part problem that I, in no way, can solve on my own. Question 1 Above is a destination sheet we use that determines which operators are cleared on specific disciplines. We'd like …
- I would like to sort by a column that has both numbers and letters in a cell. Such as 1, 1a, 1b, 1c. Right now if I sort it by it by the ascending option, it's able to do 1a, 1b, and 1c correctly, how…
- I am working on a project, and there will be MANY times that there will be multiple requests. This column is a dropdown with 2 options, "Yes" or "No". If the response is "Yes" I would like the data fr…
- I currently have a form sending data to a sheet, and then data from that first row displaying on a dashboard that I can print out for a visual representation of project data. Is there anyway that I ca…
- Hello, I have a column for Avg Handle Time, where each row is formatted as: 0:00:00 How can calculuate the average of multiple rows? I know with Excel, you can just highlight the whole column, and it'…
- Got a knotty question that I'm sure the savant's here can solve, as I am a novice at column formulas. The issue? We'd like to track average hours worked across multiple employees, however we don't wan…
- Hi everybody; it is always a happening when huge formula is working as the following one: But for any reason the formula works when I set "Kundenrelevanz" to 1,2 and 4 stars but if I change to 3 or 5 …
