Is it possible to create a calculation where a result is dependent on the date of creation of the item vis-a-vis the current date?
I have monthly reporting form submissions.
There is a category where they choose the month and another one where they choose year.
If these arrive within the first 6days of the following month or before, the value should be 1.
If the item is created after the 6th day but within the 15th, the value should be 0.5.
After the 15th of the month following the month of the category, the value should be 0.
Is this sort of calculation possible?
thanks and regards
Please sign in to leave a comment.