-
Solution to manage accidental deletion
Good afternoon, Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure…
-
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
-
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
-
Formula to pull in contents in a cell that survives deleting rows
What is the best formula to pull in the contents in a cell in the same column even if the original row is deleted? Background: I'm building a Profile Data sheet for a new blueprint. This blueprint has several optional project plans. Each plan will be on the profile data, capturing things like Start/End dates, schedule…
-
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…
-
How to pull one of the headers from the primary column which is under a hierarchy
I am trying to pull the header which has an ancestor 1 assigned to it i have a forumal below which i am tryign to tweak but i cant get it to work to get the dark blue header can anyone help me please @Paul Newcome if you are free Paul, i would appreciate your help on this please?
-
Original sheet is corrupted or has some hidden issue preventing the formula from working?
I have a sheet where a formula in one column is not being applied . However, when I save the sheet as new, the formula works as expected. Is it possible that the original sheet is corrupted or has some hidden issue preventing the formula from working?
-
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.