-
How do I add text to a formula
My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25% =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) Thanks.
-
Find First Duplicate in a Sheet
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…
-
How do you set up a project timeline to work around set meeting dates?
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…
-
"Show More" option for cells with long wrapped text
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…
-
Conditionally Lock a Cell in a Sheet
Apply a feature to conditionally lock a cell in a sheet when one or more criteria are met.
-
Way to get average number of submissions per day?
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!
-
Send notification without access to sheet
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…
-
Is there a formula to count how many times todays date is entered into a sheet?
-
Automatically delete blank rows when using a Form to add to the bottom of a Sheet
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…
-
How do I count the reason for the consult, AND the year it took place?
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…
