Due to how Notion handles recursive formulas (each day currently references the previous day's total), this example will fail after the 7th row as that's the limit on recursive iterations.
Projects
ID #
if(prop("Previous") == prop("Name"), 0, if(empty(prop("Previous")), 1, prop("Previous ID") + 1))
if(prop("Previous") == prop("Name"), 0,If
Previous is the same as Name, return 0.if(empty(prop("Previous")), 1,Otherwise if
Previous is empty, return 1.prop("Previous ID") + 1))Otherwise add
1 to Previous ID.ID
if(prop("ID #") != 0, slice("0000", length(format(prop("ID #")))), "") + format(prop("ID #"))
if(prop("ID #") != 0, slice("0000", length(format(prop("ID #")))),If
ID # doesn't equal 0, take the string 0000 and remove as many 0s from the front as there are digits in ID #., "")Otherwise if
ID # does equal 0, show nothing.+ format(prop("ID #"))Add the
ID # to the end of the sliced 0000 string.
