Text automatically entered to see if task was completed in time

[alonsogar]

So I keep a row for each item. There exists different criteria that indicates that an item is done " on time" depending on the feedback type of the item.

The criteria will be judge based on the "Days in Progress". If the " Days in Progress" exceeds the tolerable amount of days the the item was not completed in time. The criteria is as follows :


Feedback type
Acronym/Definition >5 days
Rewrite or Update Procedures >32 days
Question Problem >5 days
Incorporating PRO > 32 days


I hope that I didnt have to use a macro but by the looks of it, there is no other way around it. It would be great if a Yes or No would appear in the On Time section for each row if the Days in Progress is available.

Can anyone please help me out?

[DBY]

Hello
If you use your Feedback Type table as a lookup, then maybe a formula as following in your Table's 'On Time' field:

=IF([Days in Progress]>VLOOKUP([Feedback Type],Feedback_Lookup,2,0),"No","Yes")

In the lookup table make the second column numbers only: 5; 32 ;5; 32. Here the lookup table has been named: 'Feedback_Lookup'.

DBY