-
Lookup the latest date associated with a project from another worksheet
In my first sheet, I have a general list of all my projects and I would like to report the latest date the project was worked on. In another worksheet, I keep a database of time/dates logged on all projects. I would like to be able to lookup the latest date a project was worked on in my first sheet. Vlookup, Match, and…
-
Index/Match not pulling in Contact field. . . Read so many threads, none apply
Hello all, I am just trying to pull in contact fields for small Roster Files for events tied to an Event Master Tracker. There are columns on the event tracker that have the owner of the project/event as a contact field. I am attempting to index this field by matching the unique event identifier present in both sheets. The…
-
Can you trigger an automation or conditional formatting based on grouped cells/same cell value?
Hello, I'm doing a work project where we're installing 3 devices into all floors of a building. Those devices are represented in columns. Each time a device is installed, the value = "Yes". However, I need to trigger an alert or take an action only when all 3 devices have been installed into every floor of the building. In…
-
Formula to return a calculated value, only if the value in another column is not zero
Hello, I am looking for help to create a formula to calculate only if the value in another column is NOT ZERO. This is a description of what I am trying to do: · If [Projected Estimated Cost] is NOT ZERO, then calculate [Current Cost]@row MINUS [Projected Estimated Cost]@row. · If the value of [Projected Estimated Cost] is…
-
Planned % Complete
Hi, I am trying to add a formula to my project plan in order that I can determine what the planned % completion should be. I found a thread that recommended using =NETWORKDAYS([Start Date]@row, [Column18]131) / NETWORKDAYS([Start Date]@row, [End Date]@row) However, this returns: ">" 100% if today is ">" than the planned…
-
Have upload or attachment to form sent via email?
Greetings- Anyway to have a form attachment or upload be emailed or moved along to someone who isn't managing the grid? Setting up a trouble ticket form where people can submit info and attach a picture of a tree down in our parks. I have a automation set up if the person selects "tree down" from the form grid it…
-
Metric Sheet Automation
Hello there, Thanks in advance for the help. I have a lot of data sheets that I want to summarize in one metric sheet. The data will be grouped based on the "assigned to" column. Right now, if I add a new line to one of these sheets, I have to go into the metric sheet to manually add in a row under that appropriate…
-
Change status of a child row based on parent row
Hello, all! Is there a way to change all the statuses for child rows based on a parent row? Let's say I have a project to grow an orchard (parent row). It would have subtasks, like buying saplings, procuring fertilizer, and creating a watering schedule (child rows). If I have to scrap the orchard project, I'd mark it as…
-
Formula Issue
I am trying to write a formula to return the following: If Column A is not this, and Column B is this, return the result in Column B in Column C. Does anyone have advice? I think it should be fairly simply but I keep getting the unparsable message. Thank you in advance!
-
Logic based on multiple criteria?
Greetings- I have a form with drop-down input that allows multiple choices. Last options says "Other" which triggers the next input to appear if selected via logic. This works fine but if the users has more then one item selected (other and anything else, the next input doesn't appear. Any way to trigger hidden input if…
