-
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…
-
How do I create a pie chart from the data on my sheet? Assuming I need a formula?
I have a column with rows of dollar amounts called Grant Amount and a column with a drop down menu of three options called Scope of Work. My goal is to create a pie chart on my dashboard showing what percentage of the total amount of dollars from the Grant Amount column is going toward the options chosen in the Scope of…
-
Formula & Placement for Automating Status based on End Date
Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it! Goal: Automate Status column updating When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.'…