If formula for todays date if check box checked

I am trying to find the formular to render todays date when a check box is checked.

Best Answer

  • Meg Y
    Meg Y ✭✭✭✭✭✭
    Answer ✓

    @Starmar

    In your data complete column use the formula below.

    =IF(pre-meeting prep complete:@row = true, TODAY())

    Meg Young
    mmyoungconsulting@gmail.com

    If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

Answers

  • Meg Y
    Meg Y ✭✭✭✭✭✭
    Answer ✓

    @Starmar

    In your data complete column use the formula below.

    =IF(pre-meeting prep complete:@row = true, TODAY())

    Meg Young
    mmyoungconsulting@gmail.com

    If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

  • Starmar
    Starmar ✭✭

    Thank you Meg! I watched various videos and could not figure out how to get the formula to take. Appreciate you~

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!