Flag Formula

Laura_Murphy

Hello

I would like to make the flag red if 2 criteria are met % Column is under 80% AND Deadline is within the next 2 days?

IF(AND(% Column)@row), <80%, (Deadline)?

I'm stuck on the second half of the formula can anyone help?

Many thanks

Paul Newcome

Try something like this...

=IF(AND([% Complete]@row< .8, Deadline@row <= TODAY(2)), 1)

Laura_Murphy

Thanks so much I think this is exactly what i am looking for bit the flag column displays this message when it's input?

Paul Newcome

That is correct. The formula isn't a true/false value (flagged/unflagged). That is why it is giving you the pop-up. You can click "Allow", and everything should be working fine.

Andrée Starå

Hi @Laura Murphy,

It’s because the is Restricted for flag only in the Column Setting, and you can change it, and remove the restriction.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Laura_Murphy

Thanks both

This still Isn't working, I pressed Allow and this message is shown in the row #UNPARSEABLE and I've unchecked the box. Sorry I being a real pain!

Andrée Starå

@Laura_Murphy

Happy to help!

Can you paste the exact formula you're using?

Laura_Murphy

Hi

I'm using the one above proposed to me =IF(AND([% Complete]@row< .8, Deadline@row <= TODAY(2)), 1) I've tried changing out 1 to flagged / red but nothing happens?

Thanks

Andrée Starå

@Laura_Murphy

Double check the column names.

Can you maybe share a screenshot? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Paul Newcome

Make sure the column names match. You may also need to swap out periods for commas and commas for semi-colons, but double check the column names first.

=IF(AND([% Complete]@row< 0,8; Deadline@row <= TODAY(2)); 1)

Paul Newcome

@Andrée Starå Did I do that right with the commas/semi-colons thing?

Laura_Murphy

Paul Newcome

It is the column names.

=IF(AND([% Complete]@row < .8, [Planned Deadline]@row <= TODAY(2)), 1)

or if that doesn't work

=IF(AND([% Complete]@row< 0,8; [Planned Deadline]@row <= TODAY(2)); 1)

Whenever a column name has spaces, numbers, and/or special characters, it has to be wrapped in square brackets.

Laura_Murphy

Perfect that has worked I completely forgot about needing the square brackets. Apologies and thanks to both of you again really appreciate your help

Stay safe and have a good week!

Kind Regards

Laura Murphy

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.

Andrée Starå

@Paul Newcome

Nicely done!

https://media.giphy.com/media/3oEjI7MEKQwtRmUodW/giphy.gif

@Laura_Murphy

Glad you got it working!

I saw that Paul answered already!

Let me know if I can help with anything else!

Best, 

Andrée 

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!