Question:
Is there a way to incorporate excel type formulas onto wix/ the CMS collection?
Product:
Wix Editor
What are you trying to achieve:
Our site is used as a health & safety management system within our company, rather than a traditional type of website.
Currently one department will input the date that each Health & Safety task was last completed, e.g. Gas Safety check was last completed on 01/01/2025.
The compliance department will then go in, look at these dates and mark in a different CMS collection if these checks are compliant/ non-compliant based on the date inputted. This process is currently completed each month by the compliance team.
This will then give us a list of any non-compliant areas of health & safety within the company.
Is there a way to miss that middle step, and for the system to calculate that if that date is more than 365 days ago, then that task is non-compliant?
Hi, chloe-reed !!
Excel is a type of database, and Wix collections are also a type of database. However, I don’t think it’s possible to incorporate formulas like those in Excel directly into a Wix collection. Instead, it’s possible to achieve Excel-like functionality by using data hooks to detect changes in the collection. When a change occurs, you can retrieve the updated items, perform calculations, and then overwrite the items in the collection with the new data. Alternatively, you could use Wix’s Cron feature to schedule such processes at regular intervals (e.g., daily), allowing for automatic calculations within the collection. 
In your case, you could set up a Cron job to run a check function every day at midnight(00:00). This function would calculate the difference between the last inspection date and today’s date. If the difference is 365 days or more, the item would be marked as “non-compliant,” and if it’s less than 365 days, it would be marked as “compliant.” The function would then update the items in the collection accordingly. 
1 Like
Thank you so much for your help