Sign in to join the conversation:
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,
Hello, Trying to do a count and this formula is working for all other number ranges, except for this one. Any ideas? Formula is this: =COUNTIFS([Risk Issue Factor Priority]:[Risk Issue Factor Priority], ">0", [Risk Issue Factor Priority]:[Risk Issue Factor Priority], "<7", Status:Status, "<>Complete", Status:Status,…
I am working on putting performance evaluations into Smartsheet. We have a set of criteria that employees will be rated on, and below is our scoring scale. Scoring Scale 5 - Exceptional: Consistently exceeds expectations; demonstrates leadership or innovation in this area. 4 - Strong: Frequently exceeds expectations;…
Is there any way I can create a column formula that pulls from a parent row? "For need formula here" I need to divide the value and cost from the parent row then multiply the value in the child row. I will be having multiple parent rows so I was hoping to have a column formula
