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.
Sorry I just need abit of help understanding this:
I have column W, X, Y, Z.
If X is Rota1
and Y is Yes
, then Z will be 1
.
Hope someone can help me again. Thank you.
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
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