-
DATE Formula results in Next Day when Request is Submitted after 8pm
Hi, for our ticketing system, I am using a DATE formula to only pull the date (Date column) from when a request comes in (Request Date column). I use that "Date" as part of formula to calculate how long it took us to complete the ticket. But as you can see in my screenshot, if a request comes in after 8PM (I am on the East…
-
Returning the highest value from a column where another column has potentially duplicate values
I'm a first-time poster, thanks in advance for any assistance! My scenario is that I have many customer sites grouped under parent customers and each customer site is being upgraded in 1 of 3 cohorts (Alpha, Beta, and Charlie) which are occurring in that sequence over the course of a time period. I have added a cheater…
-
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…