ContributionsMost RecentMost LikesSolutionsRe: Text Field showing different values depending on the calculationThis worked the way I wanted it to show. Thank you!!!!!!Re: Text Field showing different values depending on the calculationFor this part of the formula If( IsNull([Started]) and Today() < [Start], the "<" won't work because the fields are date/timeRe: Text Field showing different values depending on the calculationRight now, it's showing these results LT7 shows up if a number is greater than 7 Re: Text Field showing different values depending on the calculationSo I want a field that will tell me if a task has been started or not on time. I want it to yield a result that will say "NA" if Active Dif Calc is equal to 0, and then if Active dif Calc is less than 7 days but not equal to 1 it will say "L7". And then if it is less than 1 day, it will say "L1". Start and Started are both date/time fields. And if possible, I want to add E1 if the difference between start and started dates are less than 24 hours. I hope that makes sense. I've been trying to figure this out but no luckRe: Text Field showing different values depending on the calculationSorry about that, I just changed the field names. I just have Start and Started. Start is the assigned start date and started is when they actually started the projectRe: Text Field showing different values depending on the calculation(ToDays(ToDate([Started]) - ToDate([Start])))Re: Text Field showing different values depending on the calculation(ToDays(ToDate([Started]) - ToDate([Start])))Re: Text Field showing different values depending on the calculationThis just yields a result of �NA�. What I failed to include in this is that I wanted NA if the project has started on time. Right now it only yields NA because the project�s �Started� field is not null even if the project has been started late. I need a text field that will yield different values depending on different conditions.I have posted about this a few weeks ago but I still need the right formula to it. I need a text field that will yield different values depending on different conditions. I need a field that will prompt "NA" if a project has been started on time, and them it will prompt L1 if the project is less than one day before the assigned start date and L7 if it's 7 days before the due date. This is what I have currently Re: Text Field showing different values depending on the calculationIt worked! I have another thing to add to this though. I'm trying to add a formula to this existing formula that will yield a value of "E1", if the start date which is a date/time field is less than one day away. I tried to use ">" but it's not allowed for date time field.