Forum Discussion
Looking for some guidance on a calculated column with multiple IF statements
You can try below formula:
=IF(OR(ISBLANK([Class type]),ISBLANK([Start date])),"",IF(OR([Class type] = "Math",[Class type] = "English"),[Start date]+30,[Start date]+45))I have also considered scenario in above formula i.e. if Class type or Start date are blank then end date will be empty. See output in below screen shot:
Make sure that you are using correct internal name of both the column in formula. Get hint from this link if you don't know how to find internal name of the column
Official Documentation: Calculated Field Formulas
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
You can try below formula:
=IF(OR(ISBLANK([Class type]),ISBLANK([Start date])),"",IF(OR([Class type] = "Math",[Class type] = "English"),[Start date]+30,[Start date]+45))
I have also considered scenario in above formula i.e. if Class type or Start date are blank then end date will be empty. See output in below screen shot:
Make sure that you are using correct internal name of both the column in formula. Get hint from this link if you don't know how to find internal name of the column
Official Documentation: Calculated Field Formulas
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
- Ahhhh this is great. I would not have figured this out organically, but your answer provides me a better understanding about how to solve for this situation in the future.
Thank you very much! What an amazing community!
