-
IF / COUNTIF / Blank cell
I am using the below formula but when my reference sheet has a blank cell the formula returns a Yes. I need for it to return a blank cell. =IF(COUNTIF({Option Exception Master List}, Account@row) > 0, "Yes", "No")
-
How to Use IF with Multiple Criteria and then to plug in a date - Cross Sheet Reference
I am trying to write a formula that is referencing another sheet. If a row on 2023 Training Request matches the Location Tracker (where im inputting the formula - the studio code is the identifier) AND the Role dropdown on 2023 Training Request is "General Manager" then show the date in the Location Tracker that is in the…
-
Need help converting a total elapsed time string into hours
I am incredibly stumped by this problem I am needing to solve. I have a string of elapsed time, "1mos 2w 1d 1h 43m 14s", and I need to convert it into HH:MM. And depending on the duration, we do not go beyond the "m" (minute) mark. So, "mos", "w", "d", and even "h" would not be as part of the output on my data source…
-
Exclude a child row from parent row with a formula that sums its children
I would like to add a row with formulas under a parent row that calculates the sum of its children. So i need the parent row to skip one of its children that has formulas instead of the content being summed. is this possible? In the screenshot you can see when I try to add another row of formulas, i get a circular…
-
Using dates in sheet summary formulas
Hello, I have a sheet that is pulling data from Microsoft Dynamics CRM using the connector where the date data is not coming across correctly if the column is setup as a date format. I have therefore setup the column in the sheet as a text field. I have a summary formula which uses this column to summarize data by quarter…
-
Using Countifs where column data is never the same
Trying to use a Countif formula to track a column of data, but the data in each cell is always different. Attaching a snippet of some of the data from that column. Some data does repeat, but for the most part, the column data would always be different, unlike a dropdown list. What would be the best approach to use count…
-
Date Range Validation
Based on a few suggestions and other references I calculated a dollar value using the following formula: =NETWORKDAY(DATE(2023, 7, 1), DATE(2023, 7, 31)) * [Hourly Rate]@row * [Hrs/week]@row / 5 It works well, but I'd really like the formula to reference two separate columns: Start Date and End Date so the column won't…
-
Column Formulas not appearing on Gantt Chart
Hi everyone, I have a column consisting of "expiration dates" and another set of dates called "extension dates" if an extension has been made. I have put the formula "=IF([Extension Approval Status]@row = "ENABLED", [Extension Date]@row)" in the "expiration date" column, If an extension has been made and has been approved,…
-
Formula for counting rows that are past Planned Finish date
I am trying to create a formula that will count the number of row items in my Planned Finish column that are past the date in the cell. I need a summary item so that I can use it on a dashboard to show how many projects are overdue or should be closed. I have been trying to use a COUNTIF formulas that I saw other people…
-
How to count amount of times an email address appears in the "Created By" column?
Hi, I am using a form to receive IT tickets. Within the main sheet, there is an automated "Created By" column which captures the email address of the form submitter. I want to count the amount of times that each email address within the "Created By" column appears. If this could be done between date ranges that would also…
