Forum Discussion

stephenbrownsword1986's avatar
stephenbrownsword1986
Copper Contributor
May 09, 2022

Sharepoint Lists Calculated Column IF formulas based on several options

hi all

 

would appreciate some help on creating the following formula. thank you in advance

 

it would be a IF formula

[Column Name on sharepoint list]    "Value what it could potentially be"  & the "outcome text"

 

when

[Budget Approval] states "Pending" the outcome to be "New Request"

or when
[Budget Approval] states "Approved" the outcome to be "Form with People Services"

or
[Budget Approval] states "Rejected" the outcome to be "Rejected by Budget Holder"

or
[Form Cancelled] Stated "yes" the outcome to be "Form Cancelled"

or
[Budget Approved] states "approved" & a date in [Date checked by People Services] the outcome to be "With People Analytics"

or
[Budget Approved] states "approved" & a date in [Date checked by People Services] & any text in [New position number] the outcome to state "Form created for Payroll"

No RepliesBe the first to reply

Resources