-
Numbers Only Formula
Hello, I am trying to have the column "Order/Job #" automatically populate the 6 digit number of the parent row in the column "Customer or Task Name". So basically in the screenshot below, in the WHITE row, column "Order/Job #", it would say 661181. Basically, there will be multiple children rows under each parent, and I…
-
How to populate the first day of each month across a row and spanning multiple columns
I'm trying to set up a budget tracking worksheet. In Excel, it's very straightforward to have the month populate at the top of the table in one row. The columns advance by 1 month and span 12+ months. Then each row in the table is a specific person on the project and the data within the table is the persons forecasted…
-
Help with COUNTIFS with multiple criteria in same range, where to put the OR operator
This is a frequent topic in the smartsheet community, and I think I've read most of the responses, but I can't resolve it for my particular situation. : ( Mostly I get unparseable when I add my OR criterion. This is used on a project portfolio metrics sheet, where I want to count for each particular calendar year how many…
-
Formula help
This discussion was created from comments split from: Sequential numbering of duplicates.
-
Dynamic contact column
Hello, is there any way to create a contact column that would dynamicallly change based on a different column? So for example I have 4 columns Product ID, Selling countries In Progress, Selling Countries Completed, Marketing team. The column Marketing team should be automatically populated based on an external table:…
-
Count if formulas for assigned individuals
I have a work breakdown structure and I am trying to count the number of tasks allocated to contacts in the sheet. The data is spread over multiple columns. I have tried using this formula in a sheet summary - =COUNTIF({Assigned to SME for initial build}, "Joe Bloggs") + COUNTIF({Assigned to: SME 2 (peer review)}, "Joe…
-
Use SUMIFS referencing start and end dates from another sheet
Hello, I have three sheets. The first one has four attributes (Let's call it Main): [ID, Observation Date, Group, Count] The second one has three (Let's call it Week): [Week ID, From Date, To Date] The third has all the Groups listed and the corresponding weeks where the counts will be displayed based on met criteria…
-
Sumifs total from two sheets - Errors
Folks, Looking to get a total from two sheets Vs a value in two cells and adding together for the same result. eg; =SUMIFS({Sales Order Activation Range 5}, {Sales Order Activation Range 2}, Category@row) Gets me a result. and =SUMIFS({Completed - Sales Order Activation's Range 4}, {Completed - Sales Order Activation's…
-
Partial Vlookup
Hi, I need to lookup partial value and map the tagging. There are 2 sheets, main data sheet which is connected with lookup sheet to fetch the Tag. Wherever complete match is found, tag is fetched but i also want to fetch tag in case of partial match i.e. Row3="Yellow" (as DE19-1121 in lookup sheet says Yellow which is also…
-
Help with "INDEX MATCH"
Hello, I'm kind of new to Smartsheet and I've been tasked with transitioning a lot of data into Smartsheets, with that said - I have a data sheet that I need to INDEX MATCH actuals into a forecast sheet. Whenever I try to enter an INDEX MATCH formula, it keeps saying that multiple criteria is not supported or the MATCH…