-
Formula for multiple MAX date conditions
Hi, I'm trying to create a formula that looks at the MAX date and of the MAX dates it finds (because there could be multiple entries with that date), look at the row with the MAX #'s associated with those MAX dates to check a box. I came up with this and I'm getting an Invalid error =IF(AND(MAX([Date Only]:[Date Only]),…
-
IF string results in blank than give back text
Hello, I have the below formula that looks at two different sheets to determine the status of a test result. The first index collect logic is looking for the Lot ID AND the test type are both found on the same row of the Test Log sheet. If he has found both then it looks up what the test status is and returns it back to…
-
Can I use the Countif function to count the amount of times one column is greater than another?
For example, in my Smartsheet I have two columns that I would like to compare data. "Sprinkler Head Count (Estimated)" versus "Sprinkler Head Count (Actual)." I would like to count how many times in my sheet where the Actual head count is greater than the Estimated head count. Any ideas how we can achieve this? Thanks in…
-
INDEX / MATCH Formula Question
Hello, I am missing something with executing this formula. This is my first time trying to apply to my sheet. I can only successfully return a #Unparseable error. 😥 Would appreciate any guidance you can provide. Formula: =INDEX({CI Weight}), MATCH([Task Name]@row, {Project Name}, 0) Goal: Pull in ranking (CI Weight) from…
-
Help with V-lookup
I have two sheets with the following 2 columns. column 1 - HRC code column 2 - status The HRC code will always match on both sheets but the status may be different. Sheet 1 will have the most current status but sheet 2 may have old information. I want the vlookup from sheet 2 to find the hrc code on sheet 1 and…
-
Count that excludes blanks
I have the formula below that works perfectly, but I want it to exclude anything in the column "Phase Gate Criteria Identifier" that is blank. Can anyone help add that in? thanks!! =COUNTIFS([Stage-Gate Category]:[Stage-Gate Category], "Planning & Resourcing", Header:Header, 0, [Current Phase?]:[Current Phase?], 1, [Phase…
-
Multiple duration columns
Can you have 2 duration columns in a project plan that takes into consideration weekends and holidays? Right now the current duration column does but I need another duration column for our baselines and not sure how to get that to exclude holidays and weekends like the regular duration column does?
-
Match COLLECT
Hello, I need a formula that compares two columns and returns a value in a third column if there is a match. For example, if there is a Match of Jake, Smith then it will return the dept name Name Dept Lookup Name Dept Jake, Smith Science Jake, Smith (Return Value) Thanks
-
Aging report
Has anyone built an aging report within Smartsheet? I am looking to track the following three items time between when a row is submitted and the team is responding from the time a JIRA ticket is submitted and the status is changed to close Status column when it moves from client to closed
-
Formula to calculate 2 dates within 5days
Hello, I would like to write a formula that will calculate 2 dates based on this criteria. Titled: Percentage of Requests "In Progress" within 5days I'm creating a control sheet that includes percentages only On a separate (our main sheet where things are tracked) sheet I have a "created date column" and a "date put in…