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…
This discussion has been merged.
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…
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…
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…
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.
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!
I'd like to be able to build an automation to lock a row if attachments are present. How can I make this happen?