Help with Adding Additions to IF and ISBlank Formula

Options
JD_425
JD_425 ✭✭
edited 12/09/19 in Smartsheet Basics

Hi, I am hoping someone can help with the below formula additions we would like to make as it would be greatly appreicated!

  • Today our formula provides a status of In Progress for NIR code and LI code in the SMCC Action column. Once an actual date is entered into the “Actual Date Request Completed” column it will flip the Status column to completed. If there is a code NEM the Status column will read No Action – NEM.
  • What we would like to do is add a few more codes of BDM and MIN in dropdown of the SMCC Action column and also have them read No Action like the NEM code in Status column.

Our current formula is listed below and works great but we just need to add the additional BDM and MIN codes. If anyone could please help to complete!

=IF(AND(ISBLANK([Actual Date Request Completed]@row), [SMCC Action]@row = "NEM"), [SMCC Action]@row= "BDM"), "No Action", IF(ISBLANK([Actual Date Request Completed]@row), "In

Progress", "Completed"
))

 

Capture_6.JPG

Comments