-
If x Then x in columns
Hello, Using drop down choices in columns, is there a way to take a column with a certain data value, & then in the following column, only certain choices appear in the drop down choices found there, out of many? Example: Entire set of Data consists of: A,B,C,1,2,3 Column 1: If you select A, only options 1 & 2 can be…
-
Conditional Formatting (color coding)
I would like some assistance on the best way to color code rows and columns with multiple commands. So, far I have created three forms and would like each form to be color code using colors that will inform researchers on its priority and to whom it should be assigned. I have been able to color code columns and rows with…
-
Instant Notification when a Date Changes
Hello Folks, I am trying to set up a notification to send when an original date changes to any other date. I used: When the following change occurs <Date Colum> changes to <Any Value> with In any row having no condition selected. When I change a date a notification does not get sent. Any suggestions would be appreciated.…
-
Multiple Attachment Fields on one Form?
Hello, Are you able to have multiple attachment/file upload fields on one form? I am looking to collect two different pieces of information and want to make sure both are required. I know you can upload multiple documents on the one field. Thank you!
-
Search for specific user
As the owner of multiple sheets, reports, sights, etc., is there a way to search all of these where a specific person has been given permissions? Simply put, we have a team member leaving the company and I need to remove this person from any all sheets, reports, sights, etc. and I am hoping not to have to open each item to…
-
Countifs on percent complete, month, and year
Is it possible to create a countifs statement like the following: =COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish],AND(IFERROR((YEAR(@cell), 0) = 2018),IFERROR((MONTH(@cell), 0) = 2)) ? I am trying the following equation to search for 100% complete and during a specified month and year. I am…
-
Prioritization and Forced Rank
Hi all! I'm creating an intake form to help business leaders prioritize and force rank of dependencies. Example: Main project: Develop a recyclable lid for water bottles Owner: Barney Rubble I'd like to send an update request to Barney asking him to tell me what departments he is depending on to get his project done. For…
-
Workspace cleanup without admin burden
Here's the situation: I'm trying to cleanup workspaces that are shared to me without admin burden on other users of the workspace. Here's my specific situation: 1. I am not the Owner of the Workspace. 2. I do, however, own one or more objects in the Workspace. 3. The Owner of the Workspace is not available (on sabbatical,…
-
Breaking a full page of links.
I have an entire page linked to another page. I want to break the links. Do I need to do it one by one or is there a way I can break the entire page of all of it's links?
-
Charts - comparative data colors
I am having an issue with charts and my column colors. I am getting all the same color columns. I asked about this in the webinar last week and received this answer: "Colors are going to denote different comparative values (what's labeled in your legend). If you're not comparing more that one data set, you won't have…
