Deleting/Archiving Items and Sub-items

You have access to several functions to delete/archive items and sub-items.

  • DELETEITEM, ARCHIVEITEM
  • DELETESUBITEM, ARCHIVESUBITEM
  • DELETEALLSUBITEMS, ARCHIVEALLSUBITEMS

Deleting or archiving items

To delete or archive items, you have 3 possible scenarios:

  • Deleting or archiving the current item:

For this, simply use DELETEITEM or ARCHIVEITEM without parameters.

1: [Delete]=DELETEITEM()

  • Deleting or archiving an item in the current board:

For this, use DELETEITEM or ARCHIVEITEM with the position of the item to delete as 1st parameter.

1: [Del]=DELETEITEM(3)=> Deletes the 3rd item in the current board.

Or

1: [Pos]="1|5"

3: [Del]=DELETEITEM([Pos])=> Deletes the 1st and 5th items in the current board.

  • Deleting or archiving an item in another board:

For this, set the other board as Board2 using the Board2 tab. Then use DELETEITEM or ARCHIVEITEM with the position of the item to delete as 1st parameter and the board alias as 2nd parameter.

1: [Del]=DELETEITEM(3, "Board2")=> Deletes the 3rd item of Board2.

Or

1: [Pos]="1|5"

3: [Del]=DELETEITEM([Pos])=> Deletes the 1st and 5th items of Board2.

Deleting or archiving all sub-items of an item

To delete all sub-items of an item, use the DELETEALLSUBITEMS and ARCHIVEALLSUBITEMS functions. You have 3 possible scenarios:

  • Deleting or archiving all sub-items of the current item:

For this, use DELETEALLSUBITEMS or ARCHIVEALLSUBITEMS.

1: [Del]=DELETEALLSUBITEMS()

  • Deleting or archiving all sub-items of an item in the current board:

For this, use DELETEALLSUBITEMS or ARCHIVEALLSUBITEMS and specify the position of the item in the 1st parameter.

1: [Del]=DELETEALLSUBITEMS(3)=> Deletes all sub-items if the 3rd item of the board.

Or

1: [Pos]="1|5"

3: [Del]=DELETEALLSUBITEMS([Pos])=> Deletes the 1st and 5th sub-items of the current item.

  • Deleting or archiving all sub-items of an item in another board:

For this, set the other board as Board2 using the Board2 tab. Then use DELETEALLSUBITEMS or ARCHIVEALLSUBITEMS with:

  • the position of the (parent) item in its board as 1st parameter,
  • the board alias as 2nd parameter.

1: [Del]=DELETEALLSUBITEMS(1,"Board2")=> Deletes all sub-items of the 1st item of Board2.

Deleting or archiving specific sub-items of an item

To delete or archive sub-items, you have 3 possible scenarios:

  • Deleting or archiving sub-items of the current item:

For this, use DELETESUBITEM or ARCHIVESUBITEM and specify the position of the sub-item to delete in the 1st parameter.

1: [Del]=DELETESUBITEM(3)=> Deletes the 3rd sub-item of the current item.

Or

1: [Pos]="1|5"

3: [Del]=DELETESUBITEM([Pos])=> Deletes the 1st and 5th sub-items of the current item.

  • Deleting or archiving an item in another board:

For this, set the other board as Board2 using the Board2 tab. Then use DELETESUBITEM or ARCHIVESUBITEM with:

  • the position of the subitem to delete as 1st parameter,
  • the position of the (parent) item in its board as 2nd parameter,
  • the board alias as 3rd parameter.

1: [Del]=DELETESUBITEM(1,2,"Board2")=> Deletes the 1st sub-item of the 2nd item of Board2.

Or

1: [Pos]="1|5"

3: [Del]=DELETEITEM([Pos],2,"Board2")=> Deletes the 1st & 5th sub-items of the 2nd item.