-
Count Unique Values
I have a master sheet that is essentially a list of all the schedules we currently have dealing with projects. Each project has its own project number. All i am trying to do is get a number of the projects we have scheduled to compare to the actual number of projects we have in our queue. Now for the tricky part. Some…
-
Change RYBG Color if the year is Greater than the current year
Hello, I currently have this: =IF([Wants refresh?]2 = "Yes", "Green", IF([Wants refresh?]2 = "No", "Gray")) Which is working fine, but now I want to add that if the column Refresh Year has the year greater than the current year (2019) for it to turn red. I am not sure how to write that. Any ideas? Thank you!
-
Formula help recognising multiple words
Hi, I have a formula that looks for a specific word or variance of the word, is it possible to look for more than one word? The formula i have is =COUNTIFS(Response1, FIND("shower", LOWER(@cell)) > 0) This works for the word showers or shower which is perfect, however am i am able to count if the cell contains either…
-
Show Last Month of a Quarter
Hello, I have a column that has the quarter, like Q1, Q2, Q3, and Q4. Now I'm trying to show the last month of that quarter on a new column. I tried to use IF([Refresh Eligible Quarter]@row) = Q1, "March") but it doesn't work. Any idea? Thanks!
-
Simple Sum formula not working
I'm running into an issue where it appears the formulas that I have returning a number are not available for simple math in sum formulas. Any suggestions? For example, I have a column that produces the month a project will close based upon the estimated completion date currently linking in from the individual task lists. I…
-
formula help - sum if blank
I'm trying to run a formula to sum the numbers in a netdays row if another column is blank and am running into issues. Here is the formula that I have: =SUMIFS([Requested - Complete]81:[Requested - Complete]452, Q81:Q452, "1", [Survey Required]81:[Survey Required]452, "") Any help on what I am missing would be appreciated.
-
IF Statement to set a symbol to a value - #Incorrect Argument set
Good Day, I am trying to set a Symbol value using this IF statement but I get a "#Incorrect argument Set =IF([Prev Year Difference]3, =0, "Unchanged", IF([Prev Year Difference]3, <0, "Up", "Down")) The column/cell that I am using the formula in is defined as a "Symbol" using the "3 Direction" Up, Down & Unchanged. See…
-
COUNTIF and Multi-Select
Hello all, Here is a sheet with examples of how to use a COUNTIF formula the release of Multi Select. Hope it helps! Best, Kara
-
Cross Sheet Reference/ sum values
Looking to VLOOKUP into one data sheet to find - a sales rep name where the sales stage is contracted and sum up the Estimated Value field, which sums up any dollar amount in the (estimated value) field. End result is to show a sales rep and how much they have contracted to close via a dollar amount. My formula example:…
-
Use "Created By" auto generated field as a "contact list" for use with approval workflow
I have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to use this to then send an auto-generated workflow to this contact. However, I believe workflows only work…