# If / Then for At Risk Flag

Hello!

I'm trying to add a formula for: If [Start Date]@row is in the past, AND, [Status] is [Not Started] Then, Flag the At Risk Column. Is this doable - having a IF/AND THEN formula?

Lynda

• ✭✭✭✭✭✭

Hi @Lynda Ross

Hope you are fine, try to use the following formula and convert it to column formula

=IF(AND(Start@row < TODAY(), Status@row = "Not Started"), 1, 0)

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭

I hope you're well and safe!

Try something like this.

```=IF(AND([Start Date]@row < TODAY(); Status@row = "Not Started"); 1)
```

Depending on your country/region, you'll need to exchange the comma to a period.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Thank you to both of you! Here is the formula that worked:

=IF(AND([Start Date]@row < TODAY(), Status@row = "Not Started"), 1, 0)

I love that both of you helped me so quickly! I very much appreciate it!

Lynda

😉

• ✭✭✭✭✭✭

Hi @Lynda Ross

Hope you are fine, try to use the following formula and convert it to column formula

=IF(AND(Start@row < TODAY(), Status@row = "Not Started"), 1, 0)

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭

I hope you're well and safe!

Try something like this.

```=IF(AND([Start Date]@row < TODAY(); Status@row = "Not Started"); 1)
```

Depending on your country/region, you'll need to exchange the comma to a period.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Thank you to both of you! Here is the formula that worked:

=IF(AND([Start Date]@row < TODAY(), Status@row = "Not Started"), 1, 0)

I love that both of you helped me so quickly! I very much appreciate it!

Lynda

😉

• ✭✭✭✭✭✭

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭