-
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?
-
Anyway we can automate SmartSheet to remove / delete rows.
I have a dump sheet that needs to be clear every day. Move row does not work, its adds another step into a simple task.
-
Please tell Smartsheet to improve Contact column contact population/handling!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
What formula would I use to read a date from another sheet?
I have a sheet that collects dates in a column "CO Internal Target", I want to be able to list that date on another sheet with a formula. It should be able to read the "Studio Code". Both of the columns are on both sheets. The sheet that I am wanting to read from is the "Location Tracker - SS", the sheet that it is going…
