I am trying to count the tasks not started yet so the column [% complete] is either blank or 0. I used this formula- COUNTIFS([% Complete]:[% Complete], "", [% Complete]:[% Complete], 0) but getting 0…
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has…
I have ranges of data in multiple forms. There is criteria that must match from each to be summed on a third sheet. The criteria are GL Accounts and a month Code. One of the month codes is listed as 1…
I'm working on a gantt chart that is tracking teams progress on a project using agile development. Business Case / Background: When the teams provide updates to when a task is going to be completed, t…
I am trying to enter a formula that will count when the name Kara is listed and the status is listed. I keep either getting an error or it will double count. Please help. The end goal is to find ou ho…
When I check Declined Date, it is not changing to "Declined". Can someone help? =IF(AND(NOT(ISBLANK([Submit to Design Agency]8)), ISBLANK([Submit for Approval]8), ISBLANK([Approval Date]8), [Declined …
Hi there, I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete". I've been trying different ways to organi…
I have a sheet that is referencing another sheet to provide counts on instances of certain values in different columns. What I'm stuck on is counting how many times a single word is used if other text…
Is it possible when more than one row having same value( duplicate row is submitted) an alert message goes to the user that row already exist something like this..?
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If…
