I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
I am putting together a sheet / gantt chart for a project. My project needs to be approved by several committees as it progresses through various stages. These committees have fixed meeting dates that are scheduled out a year in advance and only happen once per month. Is there a way to program the currently scheduled…
Request: When cells have long wrapped text that have more than 3 (or 5...) lines, truncate the rest and provide a "show more..." link to expand the rest of the text. This will greatly compress sheets and rows that contain longer text. Example: goes to Comments: I am aware that I do not need to wrap text, and that will…
Apply a feature to conditionally lock a cell in a sheet when one or more criteria are met.
Working on an intake form with hundreds of responses and I wanted to know if there was a formula to calculate the average amount of responses per day. Thanks!
I am wanting to create a workflow that will send a notification to a contact listed in a row without allowing access to the sheet itself. Specifically, when I receive a notice to vacate from a resident in one of our apartment buildings, I would like to send them an acknowledgement that it was received when its added to the…
I'm submitting this enhancement request, but this should really be viewed as a glitch or break-fix. It makes no sense why blank rows would appear when submitting via a Form. This is a core function of Sheets and should be more streamlined. Manually deleting rows is incredibly inefficient and has already lead to multiple…
I tried to amend this formula to report by year. Below is the formula I tried, which didn't work. The reasons are part of a drop down on another sheet. The consult date is on the same sheet, but the full date is in the cell, 10/12/2017, 11/1/2017, etc. My current formula in the TOTALS to DATE is: =COUNTIF({Reason for…
I've created the following formulas to count how many times a person's name is appearing in a configurable (Contact List) column for Project Lead and then Assigned To on another sheet: =COUNTIF({Project Lead}, Primary@row) =COUNTIF({Assigned To}, Primary@row) The Primary@row is directing to the name of the person I have…