Automation Advanced Options

I was automating a sheet and "Please set the approval settings via 'Advanced Options' popped up before I could save it so I clicked into "Advanced Options", but even after editing them, it won't allow me to save it.

I receive another pop up that says "Enter unique dropdown text values, and unique button text values"

No matter how many times I try to change everything , the pop up won't go away or let me click "OK". Please help.


Tags:

Best Answer

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    My only thought is that there needs to be 3 options in that column rather than just yes or no like I see here.

    Typically Submitted, Approved, and Denied are all showing as options (as the default)

Answers

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    My only thought is that there needs to be 3 options in that column rather than just yes or no like I see here.

    Typically Submitted, Approved, and Denied are all showing as options (as the default)

  • Thank you Kimberly, it mystifies me why there has to be 3 options. but it worked! Thank you again.

  • I get the same error message when attempting to create additional workflows that require approval AND use an existing approval column. I have multiple change controls I'm trying to create and I should be able to have the approvals in the same column, shouldn't I??

  • Senior Todo, I have the same workflow; however, I place the multiple approvals into separate columns and have the approvals cascade as they move through the approval workflow. Kimberly's note above was also helpful.

  • @Senior Todo You need to have a unique option listed in the approval column you want all of the approvals to go to for each of the three statuses for each of the workflows that require approval. Then you can set these as the options for each of the approvals you are trying run