-
Cumulative risk score per day between dates
I have a number of events, each with a start date and an end date. Each event has a risk score that is the same throughout the event duration. I would like to be able to show the total risk score for each individual day of the year, as multiple events may contribute to a venue’s risk. Thank you in advance!
-
Sumif formula with checkbox reference
Can someone provide a second look and explain why the formula isn't working the way I believe it should based on formula logic. I'm having an issue with a sumifs adding my dep amt when the cleared check box is checked. Below is my formula and my input and out put sheet. It adds it when it is unchecked. If I change my…
-
Is there a way to perform addition to an integer via an automation, workflow, or a formula?
I have a worksheet that tracks yearly tasks for technicians for potential raises or to track areas of focus. The problem: I need to track how many years a technician has met all the yearly checks. If they do then we want to perform add 1 onto their [Years Complete] value. [Current Year Potential] is a basic formula that…
-
Automation erroneously triggered
My question is how can the ZZ 10 Day Indicator col (see below) become starred if the Package Complete Date column and the ZZ Completed 10 Days Date is not populated? When this is starred it moves the row t an archive datasheet - and in this case it moved it prematurely, erroneously, and I can't for the life of me figure…
-
Recreating Report in a Sheet
Hello! Our team has a financial tracker and our timesheets in Smartsheet, and I am trying to find a way to link them. The goal is to take the number of hours worked on each project, and multiply them by our average rate to get a rough estimate of our current labor cost. Our reporting also needs to separate time between our…
-
Count cells within a column that are not blank
Hi all, trying to work out a formula to count how many cells have an entry (number or text). Can not find a formula for "is not blank". Please help.
-
Using If and Index Match across multiple sheets
I had to break down two cross sheets due to the size of data. I created another sheet with a form. I would like to have an index match formula that if a name was found at the row, it would cross-reference the sheet tied to where that data is store and return a value. This would eliminate the need to pivot into that data…
-
How do I make a nested IF formula check another cell as Priority to change status of another cell?
Hello, let me start off by saying any assistance available is greatly appreciated!!!! In our work schedule we use parent child hierarchy. Through the use of other community discussions, I found a formula that I could modify and use that would change the status of the parent row based on the overall statuses of the children…
-
Replacing rows with automation
I have a sheet where I automate importing new rows whenever there is a change in spend. I want it to replace the previous row(s) that was imported with the same placement name so only the most recent one is visible. I'm thinking of some kind of formula that would populate on rows that have the same campaign name as other…
-
If Statement Help
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")
