-
Formula Help
I have 2 columns. Annual Estimated Savings ($) Confidence (25%, 50%, 75%, 100%) I need a formula that will total the value from column 1 each time 25% is chosen etc. from the amounts in "Annual Estimated Savings"
-
HH:MM calculation in Smartsheet
I need to do a time motion study of a process, so will use HH:MM format to get total time in minutes, I am finding it difficult in smartsheet, could you please help me how can I easily subtract Start time and finish time to get total time… I searched on smartsheet community, on this link :…
-
Lose data and dropdown list when I apply a column formula
I have a working cell formula that takes the parent value and adds it to the cell: =IF( COUNT(PARENT()) = 0, "", PARENT() ) But when I apply this as a Column Formula, it wipes all existing cell data in the column and also restricts the ability to use the Dropdown List column type function. I thought I could change the…
-
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
-
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…
-
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…
-
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…
-
Issues with "OR" for multiple columns
Can someone tell me what's wrong with my formula? I know it has to do with trying to insert an "OR" in there but I've tried multiple ways and can't get it to work. Thank you in advance! =COUNTIFS([X Project Status]:[X Project Status], "Active", OR([Y Project Status]:[Y Project Status], "Active"), [Assigned to]:[Assigned…
-
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
-
Combining Countif & OR Function
I am trying to write a formula that will count the number of rows where either column A (External Successor) is not blank OR column B (Internal successor) is not blank. =COUNTIF(OR({Internal Bench} = <>"", {External Bench} = <>""))