1

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.

1
  • 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, 2016 at 21:12

2 Answers 2

5

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

2
  • Dont just apply the formula. do changes in it as per your requirement. Jun 8, 2016 at 11:14
  • I have updated the formula. Check it. Jun 8, 2016 at 12:23
1

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:
https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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