multiple If statements

Options

The below works if "Closed -Training Only" is selected.

However, if any other variable is selected i get #invalid data type



=IF(Status@row <> "Closed – Training Only", (AND((IF(Status@row <> "Completed", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), "")))))

Best Answer

  • Richard Zombek
    Answer ✓
    Options

    fixed


    =IF(Status@row = "New Submission", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "In Progress", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "On Hold", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()))))

Answers

  • Richard Zombek
    Answer ✓
    Options

    fixed


    =IF(Status@row = "New Submission", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "In Progress", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "On Hold", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()))))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!