If Function with formula

Options
Foz
Foz
edited 06/15/22 in Formulas and Functions

Hi,

Please can anyone help.....

I need to use the IF Function for the following, any help appreciated.

IFCell= CFI then return unit total as 0, If cell = not cfi then SUM A1*A2

Many thanks

Answers

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭
    Options

    remember Smartsheet is not Excel..

    So if you are talking in a single row.. this will evaluate for columns

    =IF(CheckCell@row = "CFI", 0, ColumnA@row * ColumnB@row)

    If you have static values loaded in the Primary Column in row 1 and 2

    =IF(CheckCell@row = "CFI", 0, [Primary Column]1 * [Primary Column]2)

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.

    http://www.facilityy.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!