-
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…
-
Remove Extra Commas in Join/Collect?
I have a great formula of JOIN and COLLECT together that pulls info from 11 columns. It pulls strings if they meet certain conditions with commas as a delimiter. But if the conditions are not met, I have a bunch of commas next to each other. E.g. , , , EX1, , EX4, , , , and in some cases, just 11 commas. Is there a way to…
-
IF-formula on a date range
Hi guys, For the last couple of days I've been trying to create a simple formula, but in some way it doesn't work. I want to check if the date of today falls inbetween a specific date range (2 different columns), using the IF-formula. I've tried this formulas: =IF(AND([Date 1]1>=TODAY(),[Date 2]1<=TODAY), "True", "False")…