-
Merged: A way to see which reports a column has been added to
This discussion has been merged.
-
How do I customize the Strategic Plan template so the project request form attaches to a project tas
I need assistance customizing the Strategic Plan template to the needs of my department. I don't understand how the project request sheet connects to the project A & B Task sheet. I created a form for the team to submit their strategic initiatives for approval. Once a strategic initiative a approved, how does it auto…
-
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…
-
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…