-
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.
-
Auto Generate unique ID in a column incremented from the previous max number in that column.
I am working on an asset sheet where I need to generate unique ID numbers continuing from an existing sequence. The final ID will have one of a few letter prefixes + 4 digit number. The sheet will be populated by a form through which new assets that need ID numbers as well as existing assets that already have ID numbers…
-
Using OR with JOIN COLLECT
I'm struggling with the syntax on this one. I have this formula that in its current state Joins and Collects if both Sales Lead and Sales Lead 2 match [Metric Grouping]. =JOIN(COLLECT({Master_Event and Year}, {Sales Lead}, [Metric Grouping]@row, {Master Event Info Sales Lead 2}, [Metric Grouping]@row), " | ") However, I…
-
Automation to "Change Cell Value" to embed a formula into the cell
Trying to set an automation to "Change Cell Value" 2 columns involved: "BARCODE" and "PACKAGE UID/LOT #" If "PACKAGE UID/LOT #" is not blank, then I don't want to override the data in the cell, however, in the absence of data in that cell ("PACKAGE UID/LOT #" is blank), then duplicate the data from "BARCODE" into "PACKAGE…
-
Formula to Hyperlink contents of a column into another
Hello, I have two columns, one with a URL, and one with text. Is there a formula, or automation / process that can hyperlink the URL and text into a new column? I have the need to hyperlink a few hundred rows of data and want to avoid the manual hyperlink method (copy URL, cmd K , paste link etc...)
-
Weighted AVG.
looking for some help. the formula I'm using =SUM(IF([INSPECTIONS %]@row, 0.1, "100%") + (IF([ROUGH IN %]@row, 0.4, "100%") + (IF([CABLE/WIRE %]@row, 0.5, "100%")))) * 100 + "%" I can't seem to think of a way to make this work with any % that isn't 100% Also if I use =AVG(CHILDREN()), on the Parent row it just says #Divide…