hi there,
i have a form to manage my graphic designer's projects. It includes a To Graphics date and Return to You date. How do I set the Return to You date to be today +5 or greater?
You can't really set the return date to =Today(5) because every time the sheet is opened the current date would shift... The Today() formula always updates today to be the most current date every time the sheet is opened it recalculates the date for today.
I would create an Assigned Date column that you put the current date in and then have the Due Date column calculate the assigned date plus 5 days.
or if you want working days,
I'm looking for some help with a possible parent/child formula. We have a parent row that lists the project name, then two date columns - start date and end date. The children rows list the tasks that have to be completed for the project. Each of the tasks will have a different start date and end date. The Foreman is…
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
Looking for formula help to accomplish the example below:
