Are you setting up Notion templates with formulas for your team? Add this formula in one of our expert-created Notion templates.
Are you setting up Notion templates with formulas for your team? Add this formula in one of our expert-created Notion templates.
Contents
The formula is:
if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < .1, "◼◻◻◻◻◻◻◻◻◻", slice("◼◼◼◼◼◼◼◼◼◼", 0, floor(10 * date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")))) + slice("◻◻◻◻◻◻◻◻◻◻", 0, 10 - floor(10 * date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")))))
↑ Copy and paste into Notion then switch out the bold property name/s in the formula to match the name of the property name/s you're using.
The steps to creating a date formula in Notion are:
The steps to editing a date formula in Notion are: