Task Constraints

May Ilori

May Ilori ✭

10/10/18 edited 12/09/19 in Formulas and Functions

How to you apply constraints on tasks eg. Must finish by, start on etc.

Tags:

0 ·

Comments

baddams ✭✭✭✭

10/10/18

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.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Removing commas if a field being joined is blank?
Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below: =JOIN([Pre-Bid…
Formula to Join Cells that have Content (with Line Break)
Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In my example, when I use CHAR(10). It joins the cells, but leaves blank lines if nothing was filled in for a cell. Im…
Multi Select Column to Show as Individual Rows in Calendar App
Hi! I'm trying to build a calendar for speakers assigned to a program. I really want to see a column of individual names and each program they're assigned to in a multi month view. The underlying sheet has the speakers in a multi-select column. The issue is when I have more than one speaker assigned to a program/row,…