-
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…
-
Combining formulas - not working
Good morning! I have each of the following formulas in a separate cell and works just fine. However, I need it all in one cell but cannot seem to figure it out without getting error messages. Hoping someone can help me. I must use the contain function bc its pulling data from a text column. Also I want to add that if the…
-
Finding the date that a cell changed value.
I wish to look at a status cell and work out whether it has changed in the last 7 days or not. I want to use this as part of a formula so I could say has status changed in the last 7 days yes or no and then be able to use that information with other info to generate reports so we can see where action is required.
-
Column formula from a template not allowing me to edit
I downloaded a Smartsheet template and am now listed as the owner, however it is not allowing me to edit a column formula. The column isn't locked, but the formula is somehow.
-
How to calculate variance between dates with referenced values?
Hi all, I tried using the NETWORKDAYS formula and it appears it only works when you have date columns where you enter the date manually. I have a project rollup sheet which I am trying to calculate the variance of NETWORKDAYS (which considers the non-working days) of 2 columns which references dates from another sheet.…
-
Sum of closed opportunities by current quarter, current year and year to date
I previously used salesforce, and enjoyed many features of the program, but sales slowed down as I had a slow down in sales for a few years and salesforce was too expensive to pay for and not use. I 'm trying to modify the Sales/Pipeline Template Metrics sheet to show me "Closed Won" Opportunities for the following time…
