-
filtered views
Hi all, I am trying to embed hyperlinks into a sheet that will pull up the filtered view of the sheet when clicked. Is this possible? or do I need to make and link reports, rather than a sheet filter. I'd rather not do the extra work of making reports, so I'm hoping theres a better way When I click on the link I want it to…
-
Conditionally changing cells
Hi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through automation, however the action options in automation do not offer cell changing…
-
Function statement giving me date 4 month before due date.
Hi, I have a column of due dates, I need a column listing a day four months before the due date. This will be my project start date. I was looking at =IF(MONTH>4,[Due Date]@row, Any help would be appreciated. To add on to this. I plan to set up an automation to copy rows to another sheet on the week (or day) they are due…
-
Use a reference calendar sheet as a look up table to return values to a resource planning sheet
Hello, I have a resource planning sheet (Controls Resource Planning) that lists task for individuals along with other pertinent information. I have a Start Date and End Date column. I also have Period Start and Period Finish columns. Our company fiscal calendar consists of thirteen, four-week periods. Since I don't have…
-
IF OR ISBLANK Help!
Good afternoon, I am trying to create a formula that searches 2 cells with a row, and if both are blank then it will return "Online", but if either one has a value in it then it will return that value. The two cells will never both have a value in at the same time, just one or the other. The cells are as follows:…
-
#CIRCULAR REFERENCE with =SUMIF Formula
For each month, I am trying to sum up data depending on the type of project it is. For example, "If the 'Project Type' is 'Strategic', this is the total hours for the month of February," "If the 'Project Type' is 'Operational', this is the total house for the month of February." These the formulas I tried using:…
-
Master Project List
Hello, I'd like to create a list of Projects that acts as a source to update downstream teams. See the attached image as an example of column headings. I'd like this list and its contents to be available as a live list source to other functions, such as Project Management, Marketing, IT, etc. If a list item is updated it…
-
What does the LOCK do in the summary sheet?
I have a formula in the field, I locked it but I can still edit the field.
-
Help Text on Form Fields keeps disappearing and other issues
I have a form where I have help text on a number of different fields, however the text is pretty much the same: "Please check if member is NOT current. Add any additional members under "Other" " This is for drop-down fields. (I have a line break at the end to allow for some spacing before the choices.) If I edit the…
-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
