Formula

HardWork
HardWork
edited 01/14/22 in Formulas and Functions

Image below for reference:

If the submitter chooses Radiology as the Department I want the cell to automatically fill in N/A. I keep getting error messages on my formula. Can anyone help?


Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    =IF([Department]@row = "Radiology", "[N/A]")

    This formula will pre-populate the cell with you.

Answers

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    =IF([Department]@row = "Radiology", "[N/A]")

    This formula will pre-populate the cell with you.

Help Article Resources