I am trying to get a weeks to go formula to return "0" if negative.


I have a formula =(Date@row - TODAY()/7) to return the weeks to go for a date column. I want to make this formula to prevent it from showing negatives when weeks to go are in the past. I've tried:

=IF(Date@row - TODAY()/7 <0, Date@row - TODAY()/7, 0) and it comes unparsable. I am thinking my dividing by 7 may be the issue? Please help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!