At Risk Flag Formula issues/questions

Pat Sullivan
Pat Sullivan ✭✭
edited 12/09/19 in Formulas and Functions

I searched through the Community and found a couple of formulae that either directly addressed what I want to accomplish or I thought could be modifed to do what I want.  I get the #UNPARSEABLE  error for each of them.  I'm sure I'm missing something basic (new user) since all of the responses to the solutions are positive.

I want to display the At Risk flag if the item has an End Date of less than three days from today and is not marked Complete in some way.  I started with the first formula using the column "% Complete" formatted as Text/Number.

=IF(AND([End Date]@row&lt;=Today(3), [End Date]@row&gt;=Today(),Status@row<>"Complete",[%complete]@row&lt;>1),1,0)

I did modify the above code but only to change the Column names to match my own. It's certainly the more complex of the two but others seemed to have had success.

The second one I tried was this one

=IF(AND(Complete@row = 0, TODAY(3) >= [End Date]@row), 1)

For this one I added a column "Complete" of type "Checkbox"

What other info can I provide or what am I missing?   I don't have any other formulae in the sheet.  Also, I created a new column for the At Risk flag of type "Symbols" as I can't see a way to apply a formula to the existing column since it is used in conditional formatting.  I'm not sure what it is triggered by either.

Apologies up front for the newbie questions.  One more thing looking forward...If I can get the first formula to work, does the %Complete cell have to have a value of 0 if not started for the formula to work or can it be blank until there is progress?

 

SS-formula1.PNG

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!