0

I have created a calculated column to see if the target has been met. I have tried different combinations of IF formulas. Am I missing something? Thank you

=IF([Response date]=0,"Not met",IF([Days to complete]>=[Estimated response (days)],"Not met",IF([Days to respond]<=[Estimated response (days)],"Met")))
=IF([RESPONSE DATE]=0,"NOT MET",IF([DAYS TO COMPLETE]>=[ESTIMATED RESPONSE (DAYS)],"NOT MET","MET"))

SharePoint list - target met column is not calculated properly. Days to respond > estimated response days = Not met

0

For the first formula, the last if statement, IF([Days to respond]<=[Estimated response (days)],"Met") , you only provide one branch. The syntex of IF function shall be like

IF(logical_test,value_if_true,value_if_false)

And for the second formula it seems fine and works in my end enter image description here enter image description here

Are you using number column for both days column?

Update: Column settings and result

enter image description hereenter image description here enter image description here enter image description here

8
  • I have checked that the columns are set to number. I fixed the first formula, that didn't work. I copied the second formula, that didn't work. I deleted the calculated column and re-added it, and it's still not working. Both formulas are still not working.
    – doughnut
    Mar 25 at 23:26
  • I tried a different formula =IF([Days to complete]>=[Estimated response (days)],"NOT MET","MET"). This is the !result.
    – doughnut
    Mar 26 at 0:00
  • @doughnut, then it may be better for you to check the column settings, like column type. Because it seems what ever the value is, the condition is always false. May be one of the column is in fact a single text column
    – Jerry_MSFT
    Mar 26 at 1:55
  • These are the settings for the fields. Calculated column, Estimated response date, Days to respond, formula, and output. I'm not sure what else I can try.
    – doughnut
    Mar 26 at 2:11
  • @doughnut, It seems I find the root cause. The formula in Estimated Response returns a wrong value. You shall use 5 instead of "5" as the return value (so as "10"). "5" will be treated as a string instead of a number even you set the return value as number.
    – Jerry_MSFT
    Mar 26 at 2:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.