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
answered Jun 8 '16 at 9:52
-
Dont just apply the formula. do changes in it as per your requirement. – Nagarajan Muthukumar Jun 8 '16 at 11:14
-
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
answered Jun 8 '16 at 9:59
