Status Column Formula

Nic Larsen

So in my screenshot, each of the columns in the formula are different colors and you can see how it ties those back to the rows as they are outlined in same color, whereas yours are just one solid. It means Smartsheet isn't recognizing your column names/association in the formula on your sheet. You'll likely need to hand type the formula and select your rows/columns to pick that up.

You may also be able to post the formula to notepad and then copy and paste it back. That occasionally works too.

Canteaug

I rewrote the formula and it is giving me an incorrect argument message now. @Nic Larsen

Canteaug

Nevermind @Nic Larsen. It works now! It was some tedious stuff I had to make sure matched yours. Thanks a lot for your help!

Canteaug

Hi @Nic Larsen

We have run into a dilemma with the formula above. We had our first denial, however, it is not automating the status to "Denied". I'm not sure what's going on. I remember it working properly.

IF(AND(ISDATE([Extension Requested Date]@row), [Extension Decision ]@row = "No longer qualifies for FMLA"), "Extension Denied", IF(AND(ISDATE([Extension Requested Date]@row), [Extension Decision ]@row = "Yes, w/ documentation"), "Extension Approved", IF(ISDATE([Extension Requested Date]@row), "Extension Requested", IF(ISDATE([Leave Start Date ]@row), "HR Accepted Request", IF(ISBLANK([HR Review Date]@row), "", IF(AND(OR([HR Determination Date]@row >= [More Info Requested Date]@row, [HR Determination Date]@row >= [HR Review Date]@row), NOT(ISBLANK([Denial Reason]@row), "Denied", IF(NOT(ISBLANK([Denial Reason]@row), "Denied", [More Info Requested Date]@row >= [HR Review Date]@row, "More Info Needed", "Pending HR Review"))))))))))

The status should change to denied if a denial reason The status should change to denied if a reason for denial is entered. The error we received is "incorrect argument".