Sheet Row IDs

Natalia06

Is there a way to customize the Row ID such that the prefix can be dependent on the date? For example, set prefix to "YYYY - " which means "2024 -" since the creation date is in 2024.

Leroy Noriega

You cannot add a formula to the Prefix.

heyjay

https://community.smartsheet.com/discussion/129132/sheet-row-ids

Create Your ROW ID without prefix. Create another column with the formula below, combining the creation date and the row ID. Replace column names as needed.

=YEAR([Creation Date]@row) + " - " + RowID@row

Natalia06

@heyjay - It looks like this formula will require 3 columns. One for RowID, one for Creation Date and one for that formula specifically. Am I understanding this correctly?