-
Formula to paste values generated by function
I'm trying to figure out an automatic way to run a function in a cell, and have that function paste the value, and only the value, to that cell. I don't want the formula to continue to exist within the cell. Similar to if I copied the cells post calculation, and did a paste-special of only the values. For example, =5+3…
-
Need a formula to count how many of each Support Type is assigned to each Assignee.
For example, for the DFM/DDFM Support Type, I would like to know that there are: Communication: (1) Ashley Pierce (1) Tanner May Proposal Review: (1) Alexa Briggs (2) Ashley Pierce
-
Remove Link but Keep the data
Hi, Is there to keep the previous data if the Reference if deleted. I have this formula =IF(vlookup(referencetoanotherSheer)=x, True). But if the other Sheet is deleted, I want it to maintain the value instead of showing #REF
-
Reproducible Hyperlinks
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I can then save them in their feature (finance, schedule, risk, invoices, cash flow, etc)…
-
Auto Generated Number Referencing
Hi, I noticed when using Index match on auto generated numbers something weird happens. On sheet A I use Index({desired result Sheet B}, match(sheet A @row, {search Criteria Sheet B},0),1) where Sheet A @Row is an auto generated number and search criteria sheet B is a text/number input. I found you have to use…
-
When saving as new, I want to break links including sumifs but I'm having an issue
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data is uploaded to the source report (I will also need the new data but the historical data…
-
VLOOKUP Help
I'm trying to write a formula in my driver sheet that will search for an employee ID number in the completion sheet and return the text from a column within the completion sheet. I wrote the following but it returns a #NOMATCH value if the employee ID is not listed in the completion sheet. I'd also like for it to return a…
-
Use data from a form field in the alert email title.
Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emails with the same title. Is that possible and if so, how? Cheers
-
Helper Column Formula
Hi, I want to use a helper column to uncheck a Checkbox column if a certain condition is met. i.e. If [Order Date] contains a date then [Order Required] is unchecked. I can't put the formula into the [Order Required] column as it already has a =IF(OR(ISTEXT([Quantity Required]@row), ISTEXT(Unit@row)), 1, 0) formula in it.…
-
Has anyone found workaround today() doesn't involve zapier
We want functionality where "Milestones missed in Last 30 days" are highlighted. We can identify Milestones. What functionality do we use to count the rows that have missed the milestone? I've seen responses about Today() function having a daily-touch limitation. I'm looking for the exact Logic to get Milestones missed in…
