Issue with Self-Paced Learning - Writing Formulas in Smartsheet

Heather_R
Heather_R โœญโœญโœญ

First, apologies if this is in the wrong place. Taking the self-paced learning modules, I have discovered an error in one of the test items.

Question 9 - the answer marked as correct is clearly wrong. If the task is PAST its due date, then it should be > TODAY(), not < TODAY().

image.png

Comments

  • Sandy Drew
    Sandy Drew โœญโœญโœญโœญ

    I think you may be reading this incorrectly. If the Due Date is < Today, it means it's in the past, which would then result in a Red value. If the Due Date is > Today, it hasn't occurred yet, so it's still green.

    Senior Smartsheet Consultant

    Prime Consulting Group

    Email : info@primeconsulting.com

    Follow us on LinkedIn!

  • Heather_R
    Heather_R โœญโœญโœญ

    yes, I suppose caffeine hadn't quite kicked in yet when I was looking at that - because I even double-checked my logic and was still sure it was wrong.

    feel free to delete so that this doesn't confuse someone else! :D

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!