-
Need a formula to verify with system date and return a value
I have column "Source" with text values(some text with numbers too) and date values.. I need text value to be return as it is in "Target" column. However, for the date values, it need to compare with System date. If year is greater than the current year and equal to current year but month is equal to or greater then…
-
I need help with a formula to track time withen a date range of a certain criteria
I'm looking to track the TOTAL PROD TIME of a certain criteria (say MCBB) of SPORTSTUDIO range within a set of dates. Any help with this is GREATLY APPRECIATED! If its needed this is the formula I use to track the individual TOTAL PROD TIME's: =INT([SUM OF ON AIR OFF AIR TIME]@row) + ":" + IF(([SUM OF ON AIR OFF AIR…
-
How to count a value in a column based on the values of other two columns?
I'd like to know if there is a way I can count the status of the Tasks for an Area based if the Discipline and Quarter is a given value. For example, I want to count how many "Completed" "Ongoing - On time", "Ongoing - Issue", "Active" and "Planned" there is in case of the other values are "Herb" and "23Q1" So in this case…
-
Small function with duplicate values
Hi all, Can someone help me with this dilemma. Let's say I have an ID column and a value column. Value can include numbers. These numbers can have duplicates: 1,2,3,3,4,2,etc. in rows. I'm trying to retrieve the IDs based on the values in ascending order. I can use INDEX, MATCH, SMALL, and COLLECT but because of the…
-
COUNTIF or COUNTIFS to sum blank fields
I have many columns and I need to sum the number of blanks within a row. There are a few columns interspersed that are hidden helper columns that should not be included in the count. I have not been able to get a formula to work when trying to account (and not count) for the helper columns (in this example column 11 and…
-
SUMIFS Help - Calculate a range based on current month
Hello! I'm looking for a formula that I can use to calculate a range based on current month. Attached is a screenshot of what I'm working with. I want the YTD column to provide a total sum based on what month it is currently. Example - We are currently in march, so YTD would show the sum of Jan, Feb, and March so far. When…
-
Dashboard / Report - Labeling
I am building a dashboard based off a report that was created from Sheet Summaries of 4 different sheets. The widget below shows 2020, 2021, 2022, and 2023 YTD. I would like for either the blue dot or the base of the column to reflect the year associated with the values. I am certain it must be somewhere earlier in the…
-
Formula to auto indent similar values in a column
I have several values in a given column, I was wondering if there is a formula where I can auto indent them instead doing it by hand
-
Attachment Within a Form to be Completed.
Hello Smarters, I have created a form which various contributors have access to via link. I need to include an attachment within that form so that they can complete some fields within the attached document and send it back with the form. Can this be created? Or better, is it possible for the completed form and completed…
-
Expense Sum Formula
I need to be able to calculate expenses per event and per expense type. I feel silly asking as I should know this but my brain just isn't calculating today. I have tried many variations of the following and it's still Unparsable. I've also tried adding @cell. What am I missing? =SUMIF([Event Title]:[Event Title], "MS CI…
