-
Update Copied Cell
Hello, I have an issue that a report will not rectify. I have a client facing board, once a cell in each row hits a certain threshold, the row is automatically copied to another board that has different (internal) attributes included. The problem is, there is one cell in each row that needs to continue to update. Right now…
-
Hi There, I have a column with comma separated strings. How to find the occurrence of each string?
Please see the below table. I have 20,000 responses. I need to find out how many times each response was given. I have 20000 responses. I need to find out how many times each response was given. Thank You.
-
Formula to calculate time between today and a date in the future.
I need to calculate the work days between my "Requested Customer Date" and today, minus two days. This is the formula I currently have, but it's not calculating correctly. =NETWORKDAYS([Requested Customer Due Date]@row, TODAY()) - 2
-
Formula Function Help
Current Formula =IF(ISBLANK([Actual End Time 1]@row), 0, ([Actual End Time 1]@row - [Actual Start Time 1]@row) / 100) + IF(ISBLANK([Actual End Time 2]@row), 0, ([Actual End Time 2]@row - [Actual Start Time 2]@row) / 100) Results in Actual Duration of 0 if Actual end time 1 is not entered. Want to update the first part in…
-
Information from multiple columns into one
I have a sheet that includes department and sub-department data, which is collected from a form. The sub departments all populate into different columns, so i have sub department columns (A, B, C, and D). For each row, there is only information in ONE of those columns because people only have one subdept. I want to create…
-
Dashboard Chart "unable to display chart"
Good day, I am using the pivot table to populate a chart on a dashboard from 3 columns on a sheet. Salesperson, month, contract value. that translates to a single line per sales person that I use to populate the chart. It is designed to maintain a running total of what work the salesperson has requested to be booked versus…
-
Help With Updating Rows Via a Form Submission
Hello, I am tracking laboratory instrumentation downtime and would like to be able to update the same row via a form submission in a different sheet. For example.) Sheet 1 contains the instrument names with a column for "Instrument down?" (it can either be a checkbox or yes/no statement, I don't mind either way). Sheet 2…
-
Flag is others are flagged
I have an "At Risk" column and I want one row to flag if any in a set range of others are flagged. For example, on a project template, I have a "Planning Milestone"; I want the milestone to flag if any rows within the "Planning" phase are flagged. I was attempting to use a formula like this: =IF([At Risk]95:[At Risk]98 =…
-
How to remove the "0" that appear in front of my (text) after converting the (date).
I am using this formula to convert the numerical date to a text Month only. It works, however there is now a zero in front of the text. Does anybody have a suggestion for a solution. =IF(MONTH(Created@row) = 1, "January") + IF(MONTH(Created@row) = 2, "February") + IF(MONTH(Created@row) = 3, "March") + IF(MONTH(Created@row)…
-
Can a Contact column populate based on selection in another cell?
I have two columns; Workstream and Workstream Leader. Their column types are Dropdown (Single Select), and Contact List respectively and each contains five available selections and are set to Restrict to list values only. I want the Workstream Leader column to populate with the contact that I know to be responsible for…