-
Combine values from multiple drop-downs into one field
Hi there! I'm looking to combine values from 3 separate columns into a single column. The three primary columns all are enabled to have multiple values per cell. The goal is to combine these three columns into one overall "Subcategory" column. Example: Request Type 1 = Apples, Oranges, and Carrots Request Type 2 = Milk…
-
Cross sheet reference formula drag to other cells
Hey guys. I have 48 cross-reference links that I need to add to the columns. I would like to drag the formula so that I won't need to change the reference # manually for each of the columns. My formula looks like this =IFERROR(INDEX({ProductionHopper Range 2}, MATCH($[Job #]$@row, {ProductionHopper Range 1}, 0)), "") the…
-
Formula that Calculates Week Range and Labels Week Number Accordingly
When integrating our billing week system that alternates between billing weeks 1 and 2. Smartsheet should have a formula that allows for the duration to have a range based on weekdays that triggers to automatically label every other week with either week 1 or 2 accordingly. ie. Week Start Date End Date Name Total Hours 1…
-
Can I Use a Formula in an Automation Date Field
I have sheets that have several automations that key on a particular due date. The due dates change based on the first Monday of each month so they are never the same. I have a sheet for each month of the year. Each year I have to go through each sheet and change all the due dates to match a new due date for that year. I…
-
Formula - Line Breaks
Does anybody know if this post from 3 years ago has been addressed? https://community.smartsheet.com/discussion/new-line-alt-enter-formulas I'm looking to concatenate cells with line breaks. Thanks!
-
Formula with IF, AND, CONTAINS
I need a formula that generates a different price depending on which options have been selected in two different columns. In one column I'm using the word premium to differentiate between the options (whether or not the text contains "premium" - because there are other options in the dropdown that do not contain…
-
Calculate duration: monday - friday
I have set the working days as Monday to Sunday as 7 days calendar. and I want to calculate and I would like to calculate days (Monday to Friday) count in the a duration column (created another duration column other than project setting column) I tried this formula - =IFERROR(IF(Calendar@row = "7 Days", NETDAYS([Actual…
-
Copy a Formula to Multiple Rows, but Keep One Column Ref in the Formula the Same?
Hey all! I understand that when you copy a formula with criteria in certain columns to adjacent columns, it changes the column references to keep the relationship between columns the same (ie, column 10 has a formula that references col 1 & col 3, and copying the formula from col 10 to col 11 would result in the col 11…
-
Need help with formula to COUNTM in a cross-sheet cell when Unique ID on both sheets MATCH
Hello. To enable dashboard reporting and visuals I am building a "Metrics" sheet that interprets data from a ginormous list (aka "G-List") -a separate sheet. Both sheets have [Unique ID], and G-List has approx. 40 multiselect dropdown columns (one of which is [Strategy 2023-2027]). I want my Metrics sheet to display each…
-
Date range in formula to consolidate monthly totals for other sheets
Help would be appreciated. I have multiple sheets with order details in them. I would like to create a sheet that I can have monthly totals side by side for each SKU and each pricing tier. So I thought I would just try referencing one sheet to make sure it worked before adding the other sheets, but when it come to date…
