-
Sum if formula
hi, Where am I going wrong with this formula: =SUMIF({Data Range 2}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), CONTAINS({Data Range 42}, "risk01"), {Data Range 43}) I'm trying to calulate the year to date financial impact for Risk 01. Each incident can impact multiple risks. Data Range 2 is the date of occurance. Data Range…
-
Formula to count column but exclude information within the column
I have a list of Job Classifications that is very long and I need a Countifs formula that can exclude 1 specific job class so that it can count all the others?
-
How can you get a parent approval request to show child row information?
I have a sheet I am using to obtain approvals from both the resource as well as the manager for expected time that the resource will be needed for a project (see below.) Is there a way to do this with the automation? Parent & Child Row: Automation: I have tried using the Message Includes "Includes all fields" as well and…
-
MTTR (Duration between Created and last Modified.
I have a Form I've got agents filling in, once submitted, there's a Created date and time "stamped" "Date" then row is modified, the "Modified" row updates, once "Job Completed" is "checked" row gets locked and Duration needs to calculate to the difference, which in this case is 3d 6h 10m HELP?! I've been all over, with no…
-
SUMIFS with two condition in the same column
Hello, I am having trouble creating a formula to trigger if 2 conditions are met within the same column. I am trying to sum the PO amounts for each time “Electrical” or “C Box” shows up in the CType column. Unfortunately, I am getting #UNPARSEABLE returned. This is the formulas I have tried so far: =SUMIFS({CType},…
-
Formula to add days to a date
I have a dropdown column for PM Frequency (1 month, 3 month, 6 month etc...) and date columns for last PM and next PM. I want to add the appropriate number of days to last PM to generate a date for next PM based on the PM frequency. What is the best way to write a formula for this?
-
How to put a date and time together in a column?
Hello, i am fairly new to smartsheet and Formulas, i was using a Created date column in Vlookup but looks like that column is in TEXT and is not being read as a Date and time.(maybe i am wrong). i have managed to use a couple of formulas to bring out the date and time in 2 separate columns, i want to put them together now…
-
IF and AND Question
I think this is fairly simple but I cannot seem to get it worked out. I have a Finding Status column. If "Closed", then populate a checkbox column with an unfilled flag. If the Finding Status column is "Open," then look to see if the deadline column is less than Today(), if yes, then the checkbox should be true (solid). I…
-
RYG Parent Changes with Daughter Scheduled Health Change
Dear Smartsheet Team I am trying to get Parent [Scheduled Health to reflect 'worst color' from daughter lines. The logic: if any one of Line 3 or Line 16 or Line 20 (of the [Scheduled Health] Column is Red then Line 1 is Red If any one of line 3, 16, or 20 is yellow then line 1 is yellow if all line 3, 16, 20 green then…
-
Join ancestors EXCEPT the top level
Hi Smartsheeters, I would like to group my milestone report by workstream, so I added a "join ancestors" column. I also have a "count ancestors" column that can be used. My current report is a nightmare when sharing, as the top ancestor is the project name, and I can't control how massive (and not wrapped) the group header…