-
Circular issue with countifs formula
Hi, I have a circular issue with the formula below: =COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], >0) I tried this, same issue: =COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy,โฆ
-
Index and Match formula with a contact list
I'm trying to return the assigned colleague by using a match function between the project sheet & our source resourcing sheet. I've used this exact formula connecting two other sheets and it worked great. This time it is returning the correct value but it is NOT pulling it in as a contact which means the "current user"โฆ
-
Sum Duration by Weeknumber
I have the following columns that pertain to my formula: Week Target - has a number (no formula that represents the target week of the year) Duration (minutes) - this has how many minutes each task will take. I want to create 3 sheet summary formulas that show a total of the hours of tasks set for for Last week, this weekโฆ
-
I have automatic color dots, how do I add the If status (Due Date) is complete, return gray?
=IF([Due Date]3 < TODAY(), "Red", IF([Due Date]3 = TODAY(), "Yellow", IF([Due Date]3 > TODAY(), "Green"))) currently using the above formula to automate color dots for task health, however when an item goes complete it stays as RED. I'd like it report out as a gray.
-
location and date count
Alrighty Need some help with a formula that will search a location and division for specifics and then look at the newest date from that location and division and give me a count since that date. the first two columns are static but the data sheet is updated by forms weekly. this is a shot of the metric sheet for theโฆ
-
Last 7 days with multiple conditions
I have an external sheet named Sheet 1. I want to look at Column 1 to see if it is in the last 7 days and then look at Column 2 to see if it has "Open" in the cell. If it meets both conditions, I want it to count it. The 1st part of the formula works by itself: =COUNTIFS({Sheet Range 1}, AND (@cell >= TODAY(-7), @cell <=โฆ
-
Multiple IF statments
I have a probability column (High, Med, Low).. when updated to one of these I want it to apply a predetermined percentage to a sum of rows (projected sales). Example, Projected Sales =Sum of columns 1-4, If High I want the sum to be multiplied by .75, if Med by .5 and if Low .25. I can get this formula to work for oneโฆ
-
Copying multiple contacts into a cell
Currently HR fills out a SmartSheet for a new hire. They fill in the Practice Manager and Hire Manager from a contact list. I have a formula to copy these contacts each task that belongs to these two people respectively. This way, no matter what department, the correct people are assigned and we only need one SmartSheet.โฆ
-
SUMIFS #INCORRECT ARGUMENT SET
Can some please explain the reason for the error? I don't understand what is wrong with what I have typed. =SUMIFS({STD HOURS}, {STATUS}, ="*** COMPLETE ***", {COMPLETION DATE}, AND(IFERROR(WEEKNUMBER(@cell), 0) = [Week #]@row, IFERROR(YEAR(@cell), 0) = {YEAR SELECTED})) {STD HOURS} is a column with a formula that returnsโฆ
-
Count month from another sheet
Hi All, I am using the following formula to count # of incidents logged by month. =COUNTIF({AP Invoice issues log 2021 Range 10}, IFERROR(MONTH, 0) = 3)) But I am getting an #UNPARSABLE error. Can someone advise what I am doing wrong?