Sign in to join the conversation:
How to you apply constraints on tasks eg. Must finish by, start on etc.
There are a variety of ways to trigger an action based on a column value not being reached by a certain date. So for example you can trigger a formatting change or an alert, but you can't otherwise constrain that something must happen at a certain time.
Trying to create automatic sequential ID numbers based on the date to ship and where the sample goes. Have a general auto numbering Row ID, have (thanks to reading other questions and responses) figured out how to designate a year. Now I would like to number the Internal (INT) shipments separately from the external…
*IDs have been omited for privacy but there are values in the column I need to bring in the Week # values from the Master Tracker - 2026 sheet into the Week-Over-Week Modified sheet. The group and APC ID need to match. There is a potential of duplicate APC values which is why I need the group to be a criteria as well. I…
I have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
