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((month(now()) + 1) / 12 < .1, "◼◻◻◻◻◻◻◻◻◻", slice("◼◼◼◼◼◼◼◼◼◼", 0, floor(10 * (month(now()) + 1) / 12)) + slice("◻◻◻◻◻◻◻◻◻◻", 0, 10 - floor(10 * (month(now()) + 1) / 12)))
↑ 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: