-
Issues adding an IF to COUNTIF
Hi everyone, I figured out how to use COUNTIF to count items within a column. =COUNTIF({Task Tracking - Phase}, "Initiation") + COUNTIF({Task Tracking - Phase}, "Planning") + COUNTIF({Task Tracking - Phase}, "Execution") + COUNTIF({Task Tracking - Phase}, "Close Out") I would like to create a formula that does this same…
-
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],…
