I’m looking for some help creating what I believe is a fairly simple formula. I’d like to put a date in 1 column {Warranty Issued} and a number from another column {Term of Warranty}, but in years (hence multiplying the number by 365?) and generate a date in a third column {Warranty Expiration}, then just have a status change based on the formulated date {Warranty Status}.
Use case, a warranty granted date + the number of years of the warranty = the expiration date and then a status to say “It’s Valid” or “It’s Expiring Soon” or “It’s Expired”.
FORMAT_DATE({Warranty Issued}+MULTIPLY({Term of Warranty - Years}*365))
Thank you in advance! I feel like I’m pretty close, but my syntax must be wrong.
With the first part I can help you, just try:
FORMAT_DATE(ADD_DAYS({Warranty Issued},365*{Term of Warranty}),‘DD-MM-YYYY’)
Notice you can change ‘DD-MM-YYYY’ to what format you like.
The second part involves formula column and an automation, which is not currently supported in monday (though its on their roadmap for this year).
You can either try a third-party app (like Autoboost or General Caster) to copy a formula column to a “normal” date column.
Or you can just use conditional formatting to apply a different color to a row when the dates passes, but that requires adjusting the formula to fit the available conditions
Thank you @einavpeleg for your response and suggestion! While awaiting my question to be approved on the forum, I reached out to monday.com support directly and they gave me pretty much the same answer. Thank you very much for replying and sharing a solution! Have a great day!