Forum Discussion
stephenbrownsword1986
May 09, 2022Copper Contributor
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