Formula

Lori Carenzo

Lori Carenzo ✭✭✭

05/17/18 edited 12/09/19 in Formulas and Functions

This is my current formula and it is working fine.

=IF([New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6)

I want to add that if New/Existing is BLANK - to not return anything. Not sure how I can modify this. Help?

Tags:

Formulas

0 ·

Comments

PeterG ✭✭

05/18/18

maybe this might work

=IF(ISBLANK([New/Existing]2,"", IF[New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6))

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
Formula
I am trying to identify how many surveys taken at the start of the program are from the Jacksonville market using this formula =COUNTIFS({Time of Survey}, {Time of Survey}, "Week 1 of program", {Data}, "FLJAC Jacksonville") but it retuns as Incorrect # of arguments
Index Collect with a Date Range
Hi, I am working on a tracker for our new employees to ensure our managers are completing a weekly check-in with them for 5 weeks. I need to match their name, then match collect the created date from the check-in form and confirm it falls in between their start date and date helper field (start date +7 days). I will need…