-
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…
-
Is there a better way to get the results I am looking for?
Good afternoon, all! I have been tasked with creating an in-depth catalogue of SKUs for my company. Currently, I have a set up that works but is going to be very manual with change management. I have one sheet that is my data dump. It has all of the information located in one spot. I am then going to need to pull this…
-
index match using multiple critieria
Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different ) The formula Im using gets me an INVALID…
-
Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
-
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
-
Count how many times a multi-select value was selected in a cell range or column
Hi, I am trying to count how many projects from another sheet has a specific OKR value selected in a multi-select dropdown column. Example: There are 4 projects, all of which could be assigned to a single or multiple OKR values. I need a formula to count the number of times, e.g. 'Improve Operations Efficiency', was…
-
Form with multi drop down answers - need help to count correct choices
Hi All, I have built a post training test form for a colleague, some of the questions have got multi answer choices (e.g. correct answers can be A, B, C, D or even choice of E - stating that all previous choices are correct; or could be that A,C,D are correct). If correct choice is chosen, needs to return point 1 per each…
-
Sum by Month in Report
I have a report created from 19 sheets - these sheets have delivery dates and project values. I want to sum by Month. See screen shot of what I have so far. I can't get it to sum, September, October, November and December independently. HELP
-
Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
-
Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…