-
Automation Help
I'm needing assistance with how to create this automation task. I have tried to built this out of scratch but the available selection to create the automation is not what I'm needing. I'm new to automation and may be approaching this wrong but is hoping an automation guru can help me figure out how I can get this done. I…
-
Countifs function returns #UNPARSEABLE
Hello, I would like for the equipment status to be counted if it is "Issued", the equipment type is "Tablet" for a specific region. I have changed the formula multiple times, each time "UNPARSEABLE". The formula below is the last one I used. =COUNTIFS({Asset Tracker 2 Equipment Status}, {Asset Tracker 2 Equipment Status},…
-
How can I exclude blank cells from from INDEX COLLECT criteria?
Hello, I've got a sheet with over 13,000 rows. My goal is to have end users enter "search criteria" into several cells to narrow the list to a handful of options. The criteria will be Speaker First Name, Speaker Last Name, Specialty, and State. So far, I've been able to pull the information from my source sheet based on…
-
Need to calculate number of days to completion
Hello Community, This is a more complex question than it seems. I have a Due Date that is calculated off a Completion Date on a sheet where the Due Date and Completion Date cells are used over and over again. For example, if a piece of equipment requires a 6 month maintenance schedule, it will get input via a form with a…
-
Complicated Index Match Formula
Hopefully someone can help me out with the below scenario: I need to pull Company Name from another sheet that matches the Name (ie AAA). Then I need to pull the ranking which is a different column in the same sheet that matches both Name and Company Name.
-
Auto populate with current, past, or upcoming text based on year
I am trying to auto populate a column with "Current", "Past", or "Upcoming" based on the year column. So for a row with 2023, I would want "Current", but would want "Past" or "Upcoming" based on what's in the Year column. I've put in the following formula but get an error (#UNPARSEABLE) =IF(Year@row = YEAR(TODAY()),…
-
Formula Help
I am trying to fix a formula. What I am trying to achieve is the number of days between the Assigned Date and the Created Date. The "Executed" is for when the status changes to Executed. I have a status column and date columns following for the statuses like "Assigned" , "Pending" etc. and for each status is a date column…
-
INDEX MATCH with multiple values question
Hello, I have 2 sheets. Response Form Assignment tracker Both sheets have the same following columns: Evaluator Name Candidate Name I have a check box column in Assignment Tracker that I'd like to check off if the Candidate name AND the Evaluator name match in both sheets. There will be duplicate results for each column…
-
Cell Updates from helper sheet / MAX(COLLECT?
I am trying to update a row based off a helper sheet with form entries. I am trying to take the latest entry for a certain individual and update their status. I am thinking the MAX(COLLECT function is what I am needing however am running into some difficulties. I have 2 columns column 1 representing the person and column 2…
-
How Can I use data mesh between two sheets in a push and pull way?
I need to use data mesh in a way that either sheets get updated when updates are made. also I am having problem with the execution. even though I have set the run for immediately but it still requires going to the workflow and running it before the target sheet gets updated.
