-
Formula for percentage of tasks completed by week?
Hi, I'm currently working on a sheet where I would like to correlate a percentage of tasks completed with an individual week number so I can create a line chart to plot % of tasks completed by week. Currently my formula is =COUNTIF([Week Number]1:[Completed within Scheduled Frequency]16, ="Percentage Complete") but this…
-
My SUMIF formula is returning "0", what am I doing wrong?
I have a SUMF formula which is returning "$0" for the value I am trying to sum. My range and criterion is a number (employee id) is this possibly what is throwing it off? Will the formula read a number for for range and criterion?
-
Return first non-empty value in a range
Hello everyone, I am attempting to write a formula that will search through row data and return the first non-empty value it finds. In the example below, the cell for city is where the formula will be placed. It should scan the rows [AZ Cities]@row:[CA Cities]@row and return Yorba Linda. If the state was AZ, The [CA…
-
How to calculate length of service?
Good afternoon all, Hoping to learn how to calculate length of service with the results displayed as either Years/Months/Days or Years/Months At present, I've tried a few formulae which I've found on the community previously, however there seem to be a few issues with inaccurate results. This formula seems to produce the…
-
What symbol equation can be used to indicate <,> and even $ value
I am trying to use visual symbol: dropdown list with up, unchanged, down indicators =IF([Check and Balance]@row = >0, "Down", IF([Check and Balance]@row = 0, "Unchanged", IF([Check and Balance]@row = <0, "Up"))) #invalid
-
Checkbox workflow just stopped working...
All of a sudden, the below workflow is not working. I have tested and demoed this functionality many times and it has been working great—and then Tuesday morning it just wasn't working anymore. In the automation tab, it is showing the workflows as having been just run (see below) but the checkbox not actually being checked…
-
Find and Replace
Can you do a find and replace for multiples sheets, or do you have to do a find and replace for each sheet?
-
Lookup / find value formulae
Hi there, need help with the formulae. Sheet 1 is where the data is input and will look like that Sheet 2 is my summary for calculation and formuale to populate graphs the third table is how the $ value would get populated for building graph. Can you please confirm the formulae
-
Sheet summaries OVERALL average
I was able to resolve a #DIVIDE BY ZERO Error message by using this formula =IFERROR(COUNTIFS(I:I, 1, C:C, 1) / COUNT(Hinge:Hinge), 0). However, I am currently hitting a road block on getting an accurate average from my sheet summaries. Is there a way to get an average of all summaries not labeled OVERALL that will only…
-
COUNTIF Formula not working with asterisk
Hi, I am trying to create a summary formula which will count the names in a specific column. Some cells contain multiple names, but they still need to be counted. The formula I am created does not seem to work as it returns 0 (the formula has the specific name but I have taken it out for privacy): =COUNTIF(SME:SME,…