-
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…
-
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!
-
Automation: lock row if attachments are present
I'd like to be able to build an automation to lock a row if attachments are present. How can I make this happen?
-
Customize the one click down for Card View or Gantt View in Reports
When you double click into a card/ gantt line, would love the ability to only show a sub selection of whatever columns were picked in the report vs someone having access to all that's available from the original sheet. Currently when we create reports, we love the clean view of only a few data points in a card view or…