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