-
Row Change Notification Being Triggered by Rows Added Through Form
Hi there I've setup a notification that's triggered by a row change. However when a new submission is made via the form (i.e. a new row is added via the form) it's triggering the notification as well. The notification is: "Trigger: When rows are changed AND when column1 changes to any value, or when column2 changes to any…
-
Using the same field across different forms in one sheet
Hi there, I'm working to build a request management system using forms where requestors will simply see a dashboard with icons/text and can select the type of request they need to submit. Since each request is quite different and I want to track the different types of requests, I'd like to list "Request Type" in each of…
-
Allow editing of column type when conditional formatting is disabled
Currently, 'Column Type' can only be edited if it is not being used in a conditional formatting item. I understand there are probably computational limitations with the sheet trying to re-apply a format to an item type that no longer exists under a column that still exists (would probably crash/freeze), but the only…
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
-
User Management removing someone from plan improvement request
When you remove a user from your company enterprise plan it would be fantastic if that would trigger the option to remove them from groups they are in and shared to items all in simultaneous steps. Our IT team removes them from plan however they are not checking the other options and it creates more cleanup now for group…
-
Merged: My charts randomly errored out, but I haven't touched the metrics that feed them
This discussion has been merged.
-
Hi, what is the best formula to collect a text in a range of column and return it into main column?
-
CONTAINS not finding match in second sheet
Looking to create a count of the number of times a name appears. in another sheets column. I keep getting a false result. =IF(CONTAINS({EE Schedule Range 3}, {EE Schedule Range 2}), "Yes", "No") Range 3 is with in Range 2 on second sheet. For this example Range 2 is a list of names and Range 3 is one of the cells in that…
-
I can't see what I'm doing because of the "help"
The help boxes are in the way when I click to edit them. I obviously know how to change the column name and I have already double-clicked, but I can't edit because I can't get the box to go away.
-
Add Summary Value from Sub Tasks
Hi all, I have a project tracker that has been created from a project template then manipulated. The template was pre-programmed to calculate/populate the summary value for the Preparer % Complete column but I would like the Reviewer % Complete column to have a Summary Value as well. Is this possible? Thanks in advance!
