I have a sharepoint list which contains a drop down of the values , Immediate , Hire , Specific
I have another column Grace Period which is a numeric
When the drop down column Immediate is selected the Grace Period should be a fixed zero
When the drop down Hire is selected the user can add Grace Period, but it should not be zero
When the drop down is Specific the user can add either zero or any number
How can this be achieved.
Can column validation be used. I am confused about the formula that can be used
Any help is highly appreciated