SUCCESSOR Formula

I am testing the Successor formula that was recently launched. But doesn't seem to get it working.

Dependencies has been enabled. What did I missed out?

I am looking to set up automation to inform successor that their task is ready to get started. Somehow unable to get the formula to work and also to test how to set up the automation.

Anyone who has tried this?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    It is your quotes. You have the slanted ones which are called "Smart Quotes" which (ironically enough) Smartsheet doesn't recognize as valid characters. Try retyping the formula directly in the sheet, here in the community, or in a text type program such as Notepad" (not Word), and you will see that you get the quotes that are straight up and down (like the quotes here in this comment). That should clear up that particular error for you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!