-
Reports Filter Criteria Behaviour
Hello Exports, I am building a report based on a source sheet. The report should extract the rows based on the criteria "This Week". Can you please take a look the pattern of screenshots and confirm if this is an expected behavior ? The data's appearing only when I am using "Is One Of" but not the other conditions. The…
-
Formula and Function : COUNTIFS : Invalid Data Type (Cross Sheet Referencing)
I am working on some key metrics for one of our teams that track referrals. I am getting an Invalid Data Type and I know it is due to "blank cells" in two of the columns I am looking at. ISBLANK is not my strong area and unfortunately I cannot generate the formula using the AI Tools because it is not capable of cross sheet…
-
Count and Countif Formula adding 4th Statement
I have an existing formula: =IF(COUNT(CHILDREN(Status@row)) = 0, " ", IF(COUNTIF(CHILDREN(Status@row), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(Status@row), "Complete") = COUNT(CHILDREN(Status@row)), "Complete", IF(COUNTIF(CHILDREN(Status@row), "Not Started") + COUNTIF(CHILDREN(Status@row), " ") =…
-
Forumlas that have shading to alternate every other row which also update when rows are deleted/adde
Good afternoon! I did use a pair of formulas based of digging I did on the forum, both a =ISODD and =MATCH, with an AUTOID column, but I think I'm making it harder. This sheet is based off a form which will add a row per submission. I'm wanting to alternate the shading every other row via conditional formatting, which it…
-
"IF" Formula Question with Symbol
Hi, I'm trying to write an equation so that my "% Complete" Column tells my "Progress" column to either be an empty circle symbol, a half circle symbol or a full circle symbol. There are only 3 options in the % Complete column: 0%, 50% and 100%. But I can't get anything to work for my Progress column outcome. See attached.…
-
How to count umbers in row without letters
Hello, I need to count numbers in rows but there is added letters, is it possible to count all numbers without letters? I need information as displayed in image.
-
Conditional formatting for dates that are X amount of time in the past
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. For example, once a record is greater than 5 years old then it must be archived. We would like to easily see when this occurs or be able to create a workflow to move them to another…
-
Find Matching cells between 2 sheets
Sheet 1 – thousands of registrations over many years and is considered a big archive and cannot be edited. Sheet 2 – a live sheet with registrations that is changing often, few entries and cannot be edited. Sheet 3 – my sheet that I want the following data to feed to. Sheet 1 has loads of archived entries. I would like to…
-
UTC Date Fix - Response Required
I've not been active on this site over the past 2 weeks or more, simply because I'm becoming increasingly frustrated with the limitations I'm faced with because of bugs, oversights and a lack of fundamental features. Primary for me is a fix to the UTC Server vs Local date issue. I've spent time trying to get around it with…
-
How to show/convert days to weeks on project plan
Hello All, duration column circled in blue is automated as per the project setting circled in red is all manual I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days is there a formula I can use on another column to…
