-
Is there a work around for trying to use CONTAINS() or HAS() within collect()?
I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tried it just text) off all the dates each work type has work. I am then on a separate…
-
TimeStamp Formula Value
Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match up my name and the time/stamp data and put it on my master sheet. Any suggestions,…
-
Is there a way to easily/quickly hyperlink 100's of sheets.
I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individual sheet. I understand that the desired effect can be obtained by running a report…
-
Sorting & Filtering Linked Cells From Source Sheet
I am unable to figure out how to sort and filter linked cells from the source sheet. I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard for this function due to the need for a specific layout, exporting and printing. The…
-
#NO MATCH error
Hey everyone! I seemed to have ran into an issue using a vlookup formula. When I first wrote it out it worked for that cell but when I dragged it down the whole column it no longer worked. =IF(VLOOKUP([H145 A/C #]@row, {QG Schedule Tracker Range 4}, 2) = "Not in SS", "No", "Yes") This checks if the aircraft number in that…
-
How to make a sheet that only shows the last x entries of another sheet
Hello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am running into troubles. For the line graph widget, they would like it to show the last…
-
Replicating Formula
I am having an issue where I have a formula working on one sheet but when I copy the formula to perform the exact same function on a different sheet, it does not work. I'm hoping someone could look at both sheets and let me know what I'm doing wrong.
-
Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally). But with cell linking…
-
Changing a cell's values from code in a different cell
Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF(column@row=X, different_cell=XX, different_cell=XXX)
-
Is there a way to update referenced sheets using vlookup and/or index and match?
Hi there, We have an issue where we provision a project from our intake sheet, but after it hits the project roll up sheet, we can't update the status. Here's a summary of how our workflow: Intake listing sheet - has our projects intake, which eventually end up as an "approved project". Each initiative has a unique ID…
