May 09 2022 08:51 AM
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"