1. Accueil
  2. Automotive News
  3. How to automatically generate the day of the week for not

How to automatically generate the day of the week for not

Le monde automobile 01/08/2021 65

Many friends asked, NOTON DATABASE tables can not be generated on the date of date, the answer is ok, to use the formula format in the form, not much nonsense, start below.

This paper template is derived from @, NOTION operation tutorial | Multifunction card calendar with Notion _ (゜ - ゜) つ ロ ロ ~ -bilibili. If there is an unclear template how to make or not use the usage method, it is recommended to look at the new hand | From 0 to 1, Notion Basics Full Guide _ (゜ - ゜ - ゜) つ ロ Cheers ~ -bilibili and @ Other tutorials. The tutorial is very good, this article has not described it.

How to automatically generate the day of the week for not  当然,插入列可以自己随意插入How to automatically generate the day of the week for not  列的格式选择FormulaHow to automatically generate the day of the week for not

The code is as follows (Everyone should pay attention not to copy space, especially if there is a space to delete if there is a space):

Replace (Concat ("Week", Format (DAY ("Date") - 1, 7) + 1)), "0", "7")

How to automatically generate the day of the week for not  像这样就完成啦

The effect picture is as follows

How to automatically generate the day of the week for not  用周1-周7替代周一-周日了,虽然不太符合习惯但不影响使用。主要是notion函数太少,做成中文的太麻烦了

Below is a lazy advanced method to automatically generate today's date

Still, like the above, add a column of Formula

Enter formatdate in the formula (now (), "YYYY / MM / DD")

Effect

How to automatically generate the day of the week for not

The disadvantage is that you can only record the time of the new record, you can't modify it! ! (But for some classmates, you can't modify yourself to add more restrictions, you can't drag them again, maybe you can play the role of supervision, everyone chooses it)


PREV: How do you diagnose a car battery failure?

NEXT: Les 20 SUV compacts hybrides rechargeables du salon Caradisiac Electrique/hybride 2021: quel modèle choisir ?

Articles populaires

Articles chauds
Retour au sommet