-
Formula help - summarize hours per person in plan
Hi all I found an old post which has the same problem as I do. However, I can't get my head around the formula presented as a solution in the original post, so I need some help 😅 I want to summarize hours per person per project. Each project has all people listed at the top of the plan, so I wanted to use these rows and a…
-
How can I summarize information from Column Headers across multiple rows?
I am trying to summarize information from multiple columns within a Smartsheet to identify Columns that may or may not apply to a specific Team. Using the example below, I would like to summarize the Columns that apply to Dept 1 and Dept 2. For example, the desired outcome of the example would note that Department 1…
-
I believe I need help with an IF OR formula
I am trying to create a formula where my swimlane shows as complete if the completion is complete, but if a project is in progress but the status is still green, I want it to show as On Target. How do I make my formula so that green is On Target unless it is marked as complete, in that case it would be called complete.…
-
How would i include multiple ranges from different sections of the sheet, row cells ?
-
Match Formula Help
I have created two sheets and in need of some help with a formula. Sheet 1: Vendor Directory (with columns "Vendor ID", "Vendor Pin", and "Vendor Verified"). Sheet 2: Vendor Verification (Which vendors will populate with their "Vendor ID" and "Vendor Pin") When a row is entered in Sheet 2 the formula should look at sheet 1…
-
Project Name for Project Status Log and automations
I'm working on a global update where I want to add a column to reflect the project name so all the automations include the correct project reference. We use a template that is consistent for every (new) project created. My goal is to add this new column to the overall admin template so both existing and future projects…
-
INDEX MATCH MAX Pulling Randomly
I am pulling out my hair with this formula, I have used it in this sheet in a similar fashion and in othe sheets as well but for some reason I am only getting random values returned. In the LVC.Helper Column: =IF(COUNTIF([MLL ID]:[MLL ID], [MLL ID]@row) > 1, INDEX([Label Version Code]:[Label Version Code],…
-
Copying multiple values from one column to a new sheet
Hi all, We are using Smartsheet to forecast staff LOEs across projects. We currently have a Data Input sheet where staff LOEs are entered by project (nested by Center). We then have another sheet, Enterprise Rollup, which searches for staff names and adds up their LOEs across projects to calculate their forecasted direct…
-
INDEX Match throwing incorrect answers
I am trying to use a unique identifier by column, to reference another table that has that unique identifier in it and provide it's adjacent value from another column, by row. This is the formula I'm using and it's giving me values in that list but the wrong value: =INDEX({Hours}, MATCH([Combined Work Description]@row,…
-
Creating a column from multiple columns, with conditions
I have created a sheet which is populated via a form for the auditing of stock. Each audit consists of 20 items. I'd like to create a separate sheet that only lists the items that have discrepancies. Sheet looks something like this… Would like the Discrepancy Sheet to look like this: So, the audit number, item number and…