Darren_Ledwich - profile

Darren_Ledwich · May 22, 2020

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...

Darren_Ledwich · May 30, 2019

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

Darren_Ledwich · May 23, 2020

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’)

Darren_Ledwich · May 23, 2020

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...

Darren_Ledwich · May 30, 2019

Jonathan that is brilliant. Thanks so much for the quick response too. Daz

User Statistics

User Activity

Formula to change status on anniversary

Autogenerate 4 digit numbers

Re: Formula to change status on anniversary

Re: Formula to change status on anniversary

Re: Autogenerate 4 digit numbers