Hi Community! I'm looking for some help. I've been tasked with creating a "notice tracker". The team would like the [Due Date]@row to be some what of a dynamic date. Here is a snip of the sheet and the columns I'll be using. The sheet is fed via a form. The form has "Response Due Date" but is not required. It will only be…
Hi- I have a {{Status}} which is a drop down containing the follow options "Not Started", "In Process", and "Complete". I have 4 columns which are checkboxes. I would like the {{status}} to dynamically update based on the check boxes in the columns. If all the checkboxes@row = 0 then status would be "not started" but if…
I've created a "Client Database" using a sheet. We had 400+ rows of details input via an upload during the setup. Subsequent clients are added via a Form and the new client number is assigned via "auto number". In our project portfolio sheets I am using a Index Match formula to pull client groups and client name instead of…
你好,我是寻求一个列,would dynamically update a task [Due Date] based off multiple conditions. Our current sheet setup has [Original Due Date], [Extension Due Date], [Extension] this is a check box, and [Planned Completion Date]. [Original Due Dates] = defined by governing body [Extension Due Date] =…
Hi- I'm attempting to return the "Green, Yellow, Red, Gray" colors with a column formula based off the Status and Planned Completion Date of my tasks.
Hi- I am setting up the PMO Template for my organization. I have the project intake sheet fully populated and now I am creating my project folders... Is there a formula that can be used to pull task "assigned to" info from my project intake sheet into the project plan sheet? My project plan has 50+ tasks but I want to only…