Below is Client script wrote for type: on cell edit.

If old value is not 27(Delivered to client) and change to new state 27 then it should allow only if manager review met is 'Yes'. For testing purpose i add alerts after

  if (oldValue !=27),     if (newValue==27) and before var managerreview, script is not running after   if (newValue==27). I checked the field name it is correct. This is not working on list view.

function onCellEdit(sysIDs, table, oldValues, newValue, callback)

{

      var saveAndClose =false;

        for (var i = 0; i < oldValues.length; i++)

        {

                  var oldValue = oldValues[i];

        if (oldValue !=27)

        {    

                  if (newValue==27)

                  {

                            var managerreview = g_form.getDisplayValue('u_manager_review_met');

                            if (managerreview=='Yes')

                            {

                                      saveAndClose = true;

                            }

                  }

        }

}

        if(saveAndClose == false)

                  {

                            alert("This State change is Not Allowed.");

                  }

//Type appropriate comment here, and begin script below

callback(saveAndClose);

}

Thanks in   advance..