At Risk with % Complete & Dates Formula

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

At Risk with % Complete & Dates Formula

Oh formulas. . . I feel like I am close, but could use some help.

I would like the 'risk' flag to be marked if the data meets the following criteria:

% complete is equal to or less than 50% AND

The date is within 3 days; Today; or is in the past

=IF(AND(([% Complete]@row >= ".5"), ([email protected] >= TODAY(+3), [email protected] <= TODAY(), [email protected] = TODAY(-1) )), 1, 0)

@Paul Newcome you seem to know what you are doing. Thought I would tag you (been reading/searching a lot). ;-)

Best Answer


Sign In or Register to comment.