I have made a simple dropdown column specifying quantity of a product, i.e., pint, gallon. Is there a way I can allow for a value to be added next to each selection, e.g., pint 4, gallon 1. I'm using …
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.…
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 …