Hi there.
I want to create a base to track my receipts for warranty purposes.
I can just insert the purchase date in a column and track it myself, but what I would like to do is when the entry is one year old change its status in a dropdown column fr...
Hi,
I am creating a client job tracker and would like to autogenerate 4 digit numbers, eg. 0001, 0002.
Can someome please help as I can only get a single digit or decimals so far.
Thanks Daz
Thanks everyone for your assistance.
I found a similar formula in a template post on the Universe.
This is what I ended up using.
IF(DATETIME_DIFF(TODAY(), {Purchase Date}, ‘days’) < 365, ‘Current’, ‘Expired’)
Thanks @Justin_Barrett and @ScottWorld for the quick responses.
In hindsight it’s not essential to have the result as a dropdown. I had a crack at using Zapier and haven’t gotten that to work yet either. Can you help me with an example formula to ins...
