-
Trouble with IF statement and date format conversion
Hi all, I'm having a formula issue that I need human support for. [AI is failing to translate it properly]. Here's my scenario (I'm so close!): I have an orange text column [Delayed Result Date] that sometimes contains MM/YYYY format and other times MM/DD/YYYY format. I need to make it a (yellow) date column [Delayed…
-
Annual Business Budget Template - How to change periods to align with specific months?
I am using the 'Annual Business Budget' template. I want to start the budgeting period from April 2025 (and therefore should be Period 1). However, once I add an expense from April, the sheet still picks it up as Period 4 (assumes month 4). The formula for that cell is large and complex: =IF($Value$2 = 12,…
-
How to do a cross sheet reference
I cannot believe I do not remember how to do this!!!!! I need to create a Cross sheet reference. Now I will be referencing a cell that will be TEXT, not a number. This is the sheet I will access for my formula. I have circled in Red the sheet name and the cell I want to reference. It will only be this single cell, not a…
-
Help with multiple IF ISBLANK statements
Hi, I am trying to list values, comma delimited, from a number of columns based on if the previous column is blank. So for example, based on this table: Object Code 1a Object Code 1b Object Code 1c Object Code 1d Object Code 2a Object Code 2b Object Code 2c Object Code 2d Object Code 3a Object Code 3b Object Code 3c Object…
-
Column Formula, but accesses different sheets
I am creating a Metrics sheet. Now I am working on my # of Records column (circled). The first formula (for TDL-03) is: =COUNT({TDL-03 - Certify Access_TDLs}). And the 2nd formula (for TDL-06) is: =COUNT({TDL-06 - Certify Access_TDLs}) Is there a way these formulas can be dynamic in some capacity, and reference the far…
-
Column Formulas
Hello, I found this formula to convert time into military time but I would like the formula to be a column formula, so it automatically updates. It looks like I'm not able to convert it from a cell to a column formula however, any suggestions? =(VALUE(LEFT([Modified Time]@row, FIND(":", [Modified Time]@row) - 1)) -…
-
Help to set up metrics on Project Raid Logs
Hi, how do i set up a metrics sheet to gather all information from our project raid logs. We have around 70+ Project raid logs for individual projects. I would like to create one sheet to display metrics such as - How many are red, Yellow and Green, Also which dept they sit in etc.. Im not sure if reports does this but…
-
COUNTIF & Multi-Selection Dropdown -- Count multiple entries
My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in the Multi-selection dropdown: * Apple * Pear * Grapes * Banana * Other I need guidance on how to structure the criteria for…
-
Help with IF + MAX formula with OR
Hi, I'd like to make a formula for the following purpose: We have daily quotas that need to be reached, however it changes depending on the day. Monday through Thursday the goal is 3, and Friday the goal is 1. I'd like an IF formula to do a MAX operation depending on the day. This is so that every day we can see how many…
-
Status Flow with If Statements
Here is my first IF statement that when the Site Survey task gets populated it puts it into the complete status. =IF(ISBLANK([Order Sign Date]@row), "", IF(ISBLANK([Site Survey Complete Date]@row), "Pending", "Complete")) Now that I am able to get the next task ROE in progress with the Site Survey task completed I am…