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.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communitySorry 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