Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Strange behavior with autocomplete today (unexpected, erratic)

Options
Preston
Preston ✭✭✭✭✭
edited 06/13/17 in Archived 2017 Posts

Some formulas auto completed today. Some didn't. Or appeared to move down a single row maybe? I don't see a pattern just yet. See uploaded pics. Notified support as well. Anyone else experience this? I'm off to correct 1k plus rows...

Β 

Β 

Earlier today before typical web form entry.jpg

Late afternoon after multiple web form entries.jpg

Earlier today before typical web form entry.jpg

Late afternoon after multiple web form entries.jpg

Tags:
· Share on FacebookShare on Twitter

Comments

  • Preston
    Preston ✭✭✭✭✭

    Also, this formula now produces "TBD" in instances where it previously produced "Gray".

    Β 

    =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", IF(COUNTIF(CHILDREN(), "Update") >= 1, "Update", IF(COUNTIF(CHILDREN(), "") >= 1, "Pending CO", IF(COUNTIF(CHILDREN(), "Gray") = COUNT(CHILDREN()), "Gray", "TBD"))))))

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories