Help

IF Yes, Add Columns

Topic Labels: Formulas
Solved
Jump to Solution
996 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Stacy_Carlson
6 - Interface Innovator
6 - Interface Innovator

Column #1
{Need Hotel?}
Yes or No

Column #2
{Hotel Cost (Estimate)}

{Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}

What I need is to change the column in #2 so that If {Need Hotel?} = Yes, then Do {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Make your second column a formula field with this formula:
IF({Need Hotel?}='Yes', {Estimated # Staff} * 250 * {Duration (Days)(Do Not Edit)}, 0)

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Make your second column a formula field with this formula:
IF({Need Hotel?}='Yes', {Estimated # Staff} * 250 * {Duration (Days)(Do Not Edit)}, 0)

Stacy_Carlson
6 - Interface Innovator
6 - Interface Innovator

Thank you. That worked perfectly.