-
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…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…