User Profile
stephenbrownsword1986
Copper Contributor
Joined Feb 21, 2022
User Widgets
Recent Discussions
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"634Views0likes0CommentsSharepoint Lists - Choice (type part of the choice option and relevant options appear)
hi, I'm very new to microsoft Lists. so please forgive my ignorance if this is easy or impossible to do. is there a way on sharepoint list, that when the end user enter 'Wol' then the options from the the choice list is filtered down to only show values which contains 'wol'. the default filter, only works if the option starts with Wol1.2KViews0likes2Comments
Recent Blog Articles
No content to show