Sorry I just need abit of help understanding this:

I have column W, X, Y, Z.

  • W is Dates
  • X is Rota
  • Y is Yes or No
  • Z needs to be something, for example:

If X is Rota1 and Y is Yes, then Z will be 1.

Hope someone can help me again. Thank you.

  • I see that you edited this 40 minutes ago. Are you still having trouble? I really encourage you to add what the formula you have at this point to your post. Rather than asking us to do a formula for you, give it a try and let us help you fix it. – Erin L Jun 8 '16 at 21:12

You may use a calculate column field for Z, with return type Number where you may add a formula (You may use IF conditions too in the formula) to set value for Z field. Apply below formula:

=IF(AND([X]="Quarter 1",[Y]),"1","-")

To know more about calculated column refer

  • Dont just apply the formula. do changes in it as per your requirement. – Nagarajan Muthukumar Jun 8 '16 at 11:14
  • I have updated the formula. Check it. – Nagarajan Muthukumar Jun 8 '16 at 12:23

Built your logic in Excel first
all basic functions are the same syntax for Calculated Columns in SharePoint

Here are all the SharePoint Functions available:

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.