-
Count Decisions in a Month, where decisions are made...
I am trying to determine how many credit decisions are made in a month. I have a date column that indicates the decision date and have popped in a helper column to change an April date to "4" and then COUNTIF if the answer is 4. I used: =MONTH([DECISION DATE]@row) The issues arises where no decision is yet made and in my…
-
Finding Status of duplicate entries
Hello, I am a bit stumped by what seems like a pretty straightforward requirement. I have a huge sheet that tracks the status of a series of documents through review cycles. The documents reference a process name and a batch number, which when combined make a unique entry. Each Group of documents on some occasions use the…
-
SUMIFS and Cross-Sheet Reference
I am attempting to write a formula in a new sheet that sums the effort estimate for each individual by month.I feel like I'm very close as I no longer get an "unparseable" error, but my formula is returning a value of 0 when it should not. In the formula example below, I'm attempting to pull in the total of estimated hours…
-
Attempting to look for duplicate names in one column that are between dates in another
Essentially I am trying to find out if a name in one column shows up a certain amount of times within a certain range. Essentially being, does "employee name" appear at least 2 times within 1/1/2023 and 1/31/2023. More than the 2 is not an issue, but essentially trying to find out those that are at least twice. I…
-
Return cell value from cross sheet reference under certain conditions
We are using smartsheets as a yard management system and we have a unique workspace for a particular type of shipment. I also have a Master Sheet that contains ALL trailers that have come to the facility and are currently at the facility. When a trailer number is added to the shipment in the unique workspace, I want to…
-
Formula Using OR - multiple sheets
Hello - I am using INDEX/MATCH formula to pull dates into a sheet. One particular column is different because the dates can be in one of 2 sheets. What would be the correct formula? Current formula =INDEX({3.1 Launched Apps Range 5}, MATCH([Content Name]@row, {3.1 Launched Apps Range 4}, 0)
-
Display a Result in Percent and Division
Hello, I currently have a sheet that counts a quantity of total on time (YTD) and total overall, referenced from another sheet. And then I have another column that takes this two values to give me a percentage. I have a table that shows me the percentage based per month, you can see it the upper table), the second table is…
-
Formula to automate Status Column Dropdown Selection for Card View
Hello, I'd like to automate which value is selected from the dropdown list in my STATUS column on my project plan sheet, so that I can use the card view without manual assignment beforehand of the status column. Is this possible to do a formula on a dropdown column? Or, should I be setting up an automation instead? Here's…
-
Formula help
hey guys, i need some help creating a formula that will pull through the amount of type A i have delivered month. Thanks in advance, Katie
-
Invalid Operation Error
I am trying to create a report and am stumped by this error. I have the exact same data in both columns because it is fake data. This formula works fine all the way down my column =IFERROR(AVG(COLLECT({Additional Options}, {Created Week}, [Report Date]@row, {Monitor Type}, "Monitor")), "") / 5 This formula gives me an…
