-
Dynamic Formula Change to Date Function
Hello, I have a list of "Created Dates" and I'm trying to pull the appropriate "Created Date" into each Week and under its Day of the Week in a more efficient way. So far I have used "=COUNTIF([Created Date]:[Created Date], =DATE(2020, 3, 1))" to find 1 item for the Week of 3/1/2020 on Sunday specifically. As well as using…
-
How do you Sum a Column for multiple same date entries
I have the following sheet (tracker) that I am trying to total or sum if there are multiple entries for one day. Do you have any suggestions on formulas to use? So for the below, I am hoping to get 1 daily total for 7/14/20. I have tried to create a summary sheet and reference the data from this sheet but I cannot get the…
-
Can I Cross Reference a sheet in client account to a sheet in my account?
I'm trying to enter the following formula =SUMIFS({Barcode packing lists Range 1}, {Barcode packing lists Range 2}, [PIckup Date]25, {Barcode packing lists Range 3}, [KIT# / SKU#]25, {Barcode packing lists Range 5}, "Green") where the sheet "Barcode packing lists" is under my Smartsheet Account and the formula is on a…
-
Dropdown values taken form sheet
Hi, I have a 7 sheets where I choose salespersons form restricted dropdown list. Is it possible to have one source of values to dropdown list. So I dont have to add-delete salesperson to every sheet?
-
Countifs if one range OR another meets criteria
Hi, I am trying to create a countifs formula that counts cells if one range meets criterion OR another range meets a different criterion. I have attached a screen shot of an example. In this example, I want to count the projects with a color of "Red," and either a category of "Difficult" OR a status of "complete" I should…
-
Overall Total % completed
Sorry If this is a repeat but the first post seemed to have disappeared. My Goal is to have the Top row #1 Where that checkbox is to say what the total of completed of all the subtaks below. For example the Level 4 is showing 100% completed so the Top row should show 25% completed. But Not sure how to accomplish this? Each…
-
INVALID DATA Type when using countifs formula referencing from another sheet
Hi, I am computing for weekly counts of leads generated for my report and I am using countifs formula and refer to the working sheet where my data is located. I am pretty sure that I am referencing in the correct Date Column and it's data type is also a Date. But the formula is prompting an "Invalid data type error". When…
-
Can anybody correct my below if condition ? I need that asap
=IF(OR(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",[DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)"), "FILLING"), IF(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)", [DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",OR([Priority]10 = "HIGH","MEDIUM")), "QUICK…
-
Flag columns and formulas?
Hi, I would like to use a Flag column with the following workflow: Manually enable the flag. Automation then sends an approval request once date is reached (in separate column). I would then like to have the flag clear when the "Approval Request" column gets an "Approved" response back from the automated approval request.…
-
Why is my COUNTIFS formula counting more items than necessary?
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desired amount of days") The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns…