formula with multiple conditions
2 Topics
IF Function & Filter Help
The Goal is to have one column that generates "SDR Gen" is the SRD Name and AE Name are not blank, and generate "Self Gen" if the SDR name is blank and the AE Name is not blank. Here are the two formulas I have tried, any tips? SDR Gen = (IF(Opportunity[SDR Name]<> BLANK() && Opportunity[AE Name]<>BLANK(), "SDR Gen"), IF(Opportunity[SDR Name]= BLANK() & Opportunity[AE Name]<> BLANK(), "Self Gen", BLANK())) SDR Gen = (IF(Opportunity[SDR Name]<> BLANK(), "SDR Gen", "Self Gen"), FILTER(Opportunity, Opportunity[AE Name]<> BLANK())) Any suggestions on how to make this work would be greatly appreciated.Solved550Views0likes1Comment
Return if one condition OR another is met
I am trying to create a column that returns if a project is "expired" or "not expired." (My column C) If the permit start date is less than (before) to the construction start date OR if the construction start date is blank and the permit start date is less than (before/has passed) today it is expired. Permit Start Date Construction Start Date New Column (Expired or Not Expired) What I am trying to create 6/24/2023 Expired 1/2/2022 12/30/2021 Not Expired 5/3/2024 5/15/2024 ExpiredSolved1.1KViews0likes4Comments