-
Display Hours & Minutes (Time) as Minutes
Good afternoon all, I have a column that displays time taken to do a task in this format: H:MM I would like to have a column at the end of my sheet that displays this information in minute format. Please can you help with the formatting. Thank you
-
Index and double match # INVALID VALUE
Hey everyone, I'm trying to return a value that matches two criteria in a cross sheet reference. It works just fine for the first cell but when I replicate for the others it returns a #INVALID VALUE. =(INDEX({FUP - VETCO 2022 Range 7}, MATCH($[PO Line]@row, {FUP - VETCO 2022 Range 9}, 0), MATCH($PO@row, {FUP - VETCO 2022…
-
Sum decedents
I am seeking help to Sum the total # at the parent level of all children under the secondary parent. Total should appear in the Pandora row which would be the total of Pandora July Offer + Pandora August Offer + Pandora Labor Day Offer. Total should be 12, but my existing formula is counting # of descendants instead of…
-
Using IF to return a value from another cell
Hi All, Currently we have the below system in place to return the value of a specific cell out of a specific column. So for example, If the country is Germany it pulls the information out of the Germany Column. This works great! But now comes my problem. We have added a Germany Refurbishment Column. So now it should work…
-
Where in this formula would I add in within 1000km
I use a smartsheet to track my fleet. When something meets this criteria it ticks the box and then an automation is activated. I was wondering how I would change this so somewhere in the formula the km's were within 1000 or over the RUC amount. This way before it is overdue, it sends the email. Here is my current formula…
-
Batch name formatting incorrectly
I've got an odd thing happening on one of our sheets. We do production and so we have batch names for production runs. Our batch names consist of a date, then a 3 digit code, then a suffix. So the sheet pastes together a few things entered by the production team to create the batch name. The way it happens is the…
-
How to convert to a date
HI all, I'm trying to get a text string from one column (lot code) converted into a date in another column. The first column contains numbers such as: 202405 Ideally the date column would read the first four digits as a year, and the last two as the month (all of the days can be the first). So far I have: =DATE(LEFT([LOT…
-
Glitch in Smartsheets
We seem to be having some sort of glitch on some of our sheets where when we get a message that a change happened and then a second message comes in telling us that it resolved itself. Below is what happened at 6:03 in the morning today: Then 2 minutes later it reverts back to normal: This happens at least once a month. Is…
-
How can I show Today, where someone stands within the graph?
Hi Community, I am trying to build something that will show %complete, desired %, AND where the trainee stands in comparison to the milestones all in one graph. From the progression status indicators, I have a few items that show some data. From the trainees start date and selected target finish date, I have made an…
-
How to calculate time
Hi. What's the formula to calculating time? For example, in one cell, I have my starting point of 6:00am. And in another cell, I have a finish time of 11:00am. What's the formula to calculate time between these two points? Thanks in advance.
