SYSPK✭✭✭✭✭✭

Blossoming

Myself ♀️ I started off as an entry-level employee and carved out a path in a niche field and became a certified Smartsheet architect/admin. It's been a pleasure to see Smartsheet increase its features and grow with it.

Thank you!! It gave me problems because it didn't recognize the ClientBatch field as numerical. I had to force it to be such and wrapped it all in an IFERROR for the non-client rows: =IFERROR(IF(AND(CONTAINS((VALUE(ClientBatch@row) - 1), ClientBatch:ClientBatch), CONTAINS((VALUE(ClientBatch@row) - 2),…

Got it. Thanks for explaining.

I doubt that was the case here because they also would have had to select each reference and delete them. Thank you though.

没有的t work but I was able to reset it by using the paintbrush from another column. Thanks

@Bassam Khalil Thank you that seems to be the right function. Now another problem- this column I had already make an integer column I guess by pressing the remove decimal button. Now I can't get it to reset. Even with this formula, I can only see integers. Is there any way I can reset that column so I can let the function…

Following.

I think a good workaround would be to put the alerts on the new sheet that they get moved to. But I'm still open to other ideas.

I see what the modification was. The new column I had made to move the row over, got duplicated. It was a checkbox called Archive, and now I see an "Archive2" at the very end of the sheet.