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)

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:

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"))))))

This discussion has been closed.