-
Transform time in minutes
Our Smartsheet has been build with time entered that way 2h00 0h15 0h15 1h00 3h00 2h00 1h00 0h15 0h15 3h00 0h30 18h00 I want to transform that value automatically in minutes (120 / 15 / 15 / 60 / 180 / 120 etc) Any idea on how to do it in smartsheet? thanks
-
Embed certain columns on another page?
Is there a way to publish and embed a sheet's data onto another page with only certain columns? Example - Sheet has Sprint milestones and Notes column with Gannt view. We are using Confluence/Jira tool to document and report statuses, would like to embed this gannt view but exclude the column with notes so it's a cleaner…
-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
Stumped with a simple formula - countif with sheet reference
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE. What am I doing wrong? =COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker 2018…
-
Limiting Access to Hyperlink
Is there a way to prevent the other sheet user to open the a link/URL hyperlink to any row, whenever someone else is using the same link?
-
max value by category
Hi I'm stuck on figuring this one out. I am trying to generate a sequential number("Sequence" column) by category ("Application"). I want the formula to calculate the max value of all the records in sequence where application = application in the new record (user would have selected this from a drop-down. this is what I am…
-
Compiling Survey Results
Hello All, There's a survey we ask people to fill out so we can better provide services. There are 32 specific locations and a long list of questions. I'd like to compile all of this information into a metrics sheet, and in the end create a dashboard. By some miracle was able to tally how many times the specific location…
-
vlookup help
OK....so I am struggling with this vlookup. Perhaps I can not do what I want to do. Any comments would be helpful. I have a sheet that has customer number and customer name. Customer number is auto generated and is sequential. CU1000033 is my number. Name XYZ Sports Academy. I have a pitcher that uses XYZ Sports Academy to…
-
Sorting Numbers with a "-" in it
Hi all, Probably my incompetence here but i have a confusing issue at the minute. I have a long list of job numbers and am trying to sort them in numerical order. There is a criteria that we use to create these that you should probably be aware of: * Primary number is a 5 digit numerical number (i.e.21495) * If there is…
-
Linking/adding rows using 2 spreadsheets
Hi all, I am having an issue that might be simple to solve, but I can't seem to find an efficient solution. I have 2 spreadsheets: - One with the ID, name, Lot and several other columns with product specification information - Another just with the same ID's, names and Lots, and a few bits more that don't pair with the…