Formula for using RYGB with certain criteria

Options

Hi All,

Hope you guys can help me out. I'm trying to set up a formula where it looks at 2 dates and a checkbox and return certain outputs based on whats filled in.

So the main outputs should be:

  • If Date 1 is empty and checkbox is empty = Blue
  • If Date 1 is empty but checkbox is checked = Green
  • If Date 1 is filled and checkbox is checked = Green
  • If Date 1 is within 3 weeks of Date 2 and Checkbox isnt checked =Yellow
  • If Date 1 isn't within 3 weeks of Date 2 and Checkbox isnt checked = Blue
  • If Date 1 is within 2 weeks of Date 2 and Checkbox isnt checked = Red

Hope you guys can help me out!

Tags:

Answers

  • Itai
    Itai ✭✭✭✭✭✭
    Options

    Hey @Jeffrey Wagemans ,

    Do you want the words "Blue", "Yellow"... to appear or do you want to use Conditional Formattion to color the row or cell?

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!