Hey guys, I've been unable to find a solution for this one. I have a sheet from which I "VLOOKUP" values from another sheet. This another sheet gets its values from a FORM input. When I reference anot…
I can't seem to get the right formula together in my Active Projects Master Schedule to show the Delta/Slippage in the construction schedules. I have individual columns for Original Finish (Date), Cur…
Hello Community, I have a form which people fill out and the numerical data from which is analyzed and then put up on charts in a dashboard. However, part of the form is a text box where they can type…
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW ite…
Hi, am working from a running sheet that currently has formulas but I'm trying to put the formulas into separate sheets so I can run metrics in a slightly different way and try to make the running she…
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automaticall…
Hello all! I am trying to have a cell auto populate information based upon values in another sheet. For example, in Sheet 1, I have the columns "Customer" and "Notes". In Sheet 2, I have the same colu…
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update …
Having difficulty trying to match 2 distinct values from one sheet to another. We have one dataset that tracks submissions on a daily basis from multiple locations. I been trying to find a way to matc…