Formula

HardWorkHardWork
edited 01/14/22 in Formulas and Functions
01/14/22 Edited 01/14/22
Accepted

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 WildayMike Wilday ✭✭✭✭✭
    Answer ✓

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

    This formula will pre-populate the cell with you.

Answers

  • Mike WildayMike Wilday ✭✭✭✭✭
    Answer ✓

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

    This formula will pre-populate the cell with you.

Sign In or Register to comment.