populate a field based on if a due date is x days or less.

terminator

anybody by chance know what is the easiest way it possible to set up a formula that reads 

 

 a field to auto populate a date that is say 10 days before another date (due date)

 

CaseyDuBose

How about using the NETDAYS formula? 

   Like this will trigger a flag "=IF(NETDAYS(TODAY(), [Due Date]2) < 10, 1)"

See an example here: https://app.smartsheet.com/b/publish?EQBCT=5da7f6319a5946e0be42ae317f4ac547

 

Paul Newcome

Try something like this...

 

=[Due Date]@row - 10