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.
I am building a form with a repeating feature for study drugs. The form includes 10 questions about the first drug, with branching logic in 2 of those questions. If the answer is YES, a text field appears for more information. This works fine for the first drug. The last question asks if there is another drug. If the…
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;…
