-
Update a Symbol column based on another sheet's checkbox, whilst maintaining other information
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 to automate this based on the Cleared column in our main training source sheet (see picture below). When that checkbox is…
-
Help with sorting numbers and letters that are combined in one cell?
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, however it separates it from the numbers that don't have any letters. For example: This is what it does: 1 2 3 1a 1b 2a 2c 3b…
-
Copy row for all columns before "Yes" Column
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 from that row, all columns PRIOR to that column copied to the next row. If the dropdown selection is "No" nothing is done.…
-
Dynamically Updating Dashboard Using Forms
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 can choose which row of data I want to show on the dashboard (aka choose which project I would like to visually see)? Thank…
-
Is it possible to calulate average of a time metric?
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'll calculate the average automatically. How would this be done in Smartsheet? Thanks in advance, -Cyrus
-
Unmark a checkbox if any instance of another sheet's checkbox is marked
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 want the employees who are currently training to dramatically offset the data. Thus, we'd like to check a box indicating that…
-
Index; Match formula - 1-5 star defaults
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 stars there is "no match" Any idea why it is ... ?
-
Fomula cross sheets | lead scoretable
For any reason this formula does not yet work properly. Has anybody an idea? Furthermore, do you have proposals for more KPI´s or sheets you can share?
-
Column Formula Not Filling All Rows
I have a column formula that isn't filling all rows. I have a row id with auto numbering and it's only going to 4 rows. I need it to fill in the whole sheet so that my index match formulas can look up if another row is created in another sheet. I'd like to get the auto numbering column to continue filling in the rows for…
-
Drag and Drop or Move Summary Sheet Fields
Is there another way to move fields other than just the move up or down with one increments?
