-
Collecting Duration a Row is on a Status
Hello, I am working on a sheet where we have several statuses that can go in just about any order. We have a suggested flow, but it's more to help the user read through and make sure they didn't miss anything. I've listed the statuses below for reference. For example, the user could go from 1 to 2 to 3 to 4c to 14 to 16.…
-
Summary formula
Hey I'm trying to do this in a Sheet Summary: If [Date] is today, then show me the value in the same row in column G. This works for an individual row (1) =IF([Date]1 = TODAY(), [G]1, 0) But I can't get it to work with @row to search all the way down the sheet to look for the current date, I've tried these: =IF([Date]@row…
-
Need help with a formula to pull in data with a certain criteria from a column ...
Hey Folks, Need help with a formula to pull in data with a certain criteria from a column in a Sheet source into a Metric Sheet. I'm wanting to only pull in a summary of 2 or more ( 2 = >) Jobs meeting the criteria for any given month. So in the Archive Sheet screenshot below, if rows 294 through 305 were January for Line…
-
Count Multi-Select Options
Hi Community, I have a multi-select column where I need to count the number of values selected (just the total, not individually). Is there a formula to help with this? Below is a screenshot of my cell (Rollover) and the outcome I'm looking for (Months Rollover). Thank you as always! ~Jaime 😀
-
Automatically update Unique names in a ranking sheet from a survey intake sheet
Hi All, I am currently building a system to rank speakers. I am try to copy unique names from the survey sheet to the ranking sheet so that I can sort them by some statistics. However, I am having trouble figuring out an automation that correctly identifies the unique names in the survey sheet and also updates the ranking…
-
How to track yearly metrics wo updating my formulas each year?
Greetings, I'm curious is there a way I'm not aware of to easily track yearly metrics without having to go into each formula and update the year? Normally, I would create a formula that says count if one thing is met as well as if it's in "2024". However, I have to update my formulas at the start of each new year. Is there…
-
VLOOKUP Not Working With Primary Column Indented Values
I have a nested IF statement with a VLOOKUP that seems to have stopped working. For debugging, I've stripped out all but the VLOOKUP function and made the search value static, "DSHS". Formula: =VLOOKUP("DSHS", [Agency & Administration]23:[Agency-Div Sort Order]24, 22, false) "Agency & Administration" is the Primary Column…
-
Issues with "Record a Date" Automation
Hi all, Any idea why this automation isn't recording a date? We have a formula that's designed to return a value of "Reorder" whenever the inventory for that products dips below a certain threshold. The formula is working, but it's not being recognized as a trigger with the attached automation. Any advice would be much…
-
Display Most Recent Created Date AND Time
I created a simple check-in form whereby the system Created Date field is to be the entry time. It will be a running sheet where all punches are stored so, for reporting purposes, need to pull out only their most recent date/time for display - the 'time' piece being my challenge. (Also have "Check-in / Arrival" criteria…
-
Cross Reference Sheet with Drop Down so I can use Conditional formatting
HI there, So I have a reference sheet, listing down all Australian Public Holidays by State (multiple drow-down). What I would like to do is to identify these holidays in my Destination sheet, and display if the holiday is either QLD, VIC or NSW or all three. I am currently using a helper column to identify if the dates…