-
Sumif Match within a Date Range Help
Hi There, I'm working with this formula: =SUMIFS({Weekly Sheet - Company Name Range 1}, {Weekly Sheet - Company Name Range 2}, ="Initiative Name", {Weekly Sheet - Company Name Range 3}, >=DATE(2023, 10, 1), {Weekly Sheet - Company Name Range 3}, <=DATE(2023, 10, 31)) This formula pulls from a another sheet and says if it's…
-
Duplicate (countif) keeps showing false value
I am using the countif function to show if a duplicate exists, but it keeps counting when there is no duplicate. =COUNTIF(EID:EID, EID@row) It works for the previous data I created, but when I add more using the forms, it always shows 1 as a duplicate count for the column. Even when I type in random letters and numbers, it…
-
Multiple COUNTIF statements to return a value
Phoning a friend.. I am repurposing a sheet to be used for tracking recurring tasks. There may be activities either weekly or month is not required, so I want to mark the activity (parent) as “N/A” and not “Complete”. I have been able to adjust formula for everything except when all child status is are “N/A”. I believe I…
-
Formula Error
Hi, I can't seem to know where the error on the formula is. Or am I just using the wrong one. What I would like is that if there is not date on the Actual Completion Date, for it to be 0. If there is a Date, to enter the month number. =IF(NOT(ISBLANK([Actual Completion Date]@row), "", IF(ISBLANK([Actual Completion Date],…
-
INDEX/MATCH Function Trouble
Hi Community, I am not the best with formulas and having trouble. I have a Master Data sheet that has all my information about what each chemistry needs to be tested. I have my new sheet, where I want to be able to enter in my chemistry, then the sheet will pull information from the Master Sheet and fill it in, according…
-
Due date based on weekdays
I can't figure out how to create a formula that shows a due date based on 7 workdays vs. 7 days. I've tried everything I can find online, but it always shows up as invalid.
-
Formula for using priority symbols
Hi! I want to create a formula where I can count the children under each header in my Task Name column I have in my project plan. Each child in column Task Name has a high, medium, and low priority symbol (the down blue arrow, yellow dash, and red exclamation point) in a column called Priority. I want the header to…
-
Need Resource Deficiency Formula corrected
Hi there, Im wanting to track resource deficiency on my projects. I'm using Capacity planning templates for smartsheet and the deficiency formula is not giving me a correct formulation. Given that Total project Demand (HRS) = Sum of all hours per week from Level of Effort column Utilization Rate is Level of effort…
-
2 Part Question on Averages & Calculations in Reports
Hi folks, 2 part question: here is that when looking at individual rows in a Report, the calculations are correct for representing % difference between two #'s as seen below (difference between A and B = C). For example in the green boxed check-marked area you can see that the calculations make sense as would all of the…
-
LOOKUP with 3 criteria in different sheets
I have a "template A" where we collect all the PO numbers by different Country, Vendor name and Payer. In "template B" I want to create an automatic search function for the corresponding PO according to information in the 3 cells of the columns Payer, Country and Vendor. I understand that it would be the equivalent to…