-
Report Widget in Dashboard
Is there a way to share the Gantt chart separately in a dashboard without showing the report? Because of the current layout, both are included in the same widget and you have to scroll to see all the information on either one. Previous discussions regarding this topic indicated that changes were pending. Is there any…
-
Conditional Formatting not working?
Hi, all. As the attached shows, I have a rule to turn the whole row a color if the Task Name contains "S18 D1". But, only one row is colored? Am I doing something wrong? Thanks!
-
Last value in a range (Return)?
I have a column (set of cells) which I'm using to attain Sum and Count figures from a series / row of numeric information. In addition I need to return the last entry made in the series. For example: There are 52 weeks in the year and we are collating information weekly and entering these figures into the corresponding…
-
Different task colours on different calendars
I have my calendars setup so my Task Name combines with the 'Assigned Person' on their own separate calendars. When printed these tasks are their predetermined colour so they can't be mixed up. However I have created another calendar that shows the timeline for the entire task and I would like all of the task to be the…
-
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…
