-
COUNTIFS multiple references to another sheet
This formula gives me an error #INCORRECT ARGUMENT =COUNTIFS({Total Lot Status Global-AgingInventoryDays}, <>"", {Total Lot Status Global-New Division}, "West", {Total Lot Status Global-SalesStatus}, "Spec") If I isolate each range and criterion under a simple, COUNTIF formula, then all three criterions work fine. It's…
-
I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?
I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET. =COLLECT({2024 All Projects}, {2024…
-
Nested IF formula with If/And
Hello, I have the following formula that works, I just can't figure out how to include the date qualifier. Can someone please help? Thank you in advance! If the assigned PCD is one of two people, I need my manager column to read Manager A's name. If it is anyone else, I need it to show Manager B's name. I want to add that…
-
Multiple Criteria
I am working on pulling information using a countifs =COUNTIFS({020-Contracts - In Queue Range 1}, "Agency Wide", {020-Contracts - In Queue Range 3}, "Requested") Here in lies my issue, for the range 3, I want it to only count if its any of these: 1-Requested 2-Assigned 3-In Progress 4-Approvals Requested 5-Obtaining…
-
Calculate a date based on the status of another column drop down
Hi, I thought I was getting closer to figuring this one out but hit a wall! I have one column that has a dropdown menu. When one of two choices is selected, I want to calcuate a due date based upon the date a report was finalized. I'm adding a screenshot so hopefully this makes more sense. So when Initial Evaluation…
-
How do I join specific cells from multiple sheets?
The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potentially others, but I'm struggling with making it work the way I want it to. This is what I have: This sheet will be duplicated…
-
Mixed Fraction Formula
I am trying to get a cell to read 12 3/4 as 12.75 so Smartsheet will complete the math for the sheet in another cell.
-
Adding Days to a Date derived from a formula
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line. Both columns are set to Date Types. The Submission Date is derived from a formula -…
-
Is there a way that I can have a return date once something is "APPROVED"?
Hello! I'm trying to have a cell populate with the date that "APPROVED" is clicked. Ex: If "DC Ha Review" has "APPROVED" chosen in the dropdown, I wanted the Approval Date column to populate with that date. So, as I've chosen "APPROVED" in that column, the Approval Date column would have today's date. Any help would be…
-
Formatting not staying the same for new form fills
I noticed that in my sheets the $ currency column formatting or the align formatting do not stay the same as the rest of the column for new form fills. For example, before if I inputted in 100 in the $ section it would go to the sheet as $100 and on certain columns they would be automatically centered but now they just…
