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 change…
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 appr…
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…
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…
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 'Proj…
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 availa…
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 …
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 …
Hi, Since yesterday in the afternoon, we've been having some issues with two things: 1- Comments are not working when you try to edit them from the search section. When you actually click into the she…