Notion Formula Date Errors: Fix Date, Text, List and Empty Inputs
A date-looking value can be Text or a List. Trace the input type, keep date calculations as Date values, and decide whether an automation should clear or preserve its target.
A practical library for building,
organizing and working in Notion.
Troubleshooting
A wrong date, an empty rollup and a client-access problem need different guides. Choose the symptom you can describe, then follow the checks in that article.
Start with the visible problem rather than a broad workspace rebuild.
Choose the symptom you can identify: the wrong day count or a value with the wrong input type.
A date-looking value can be Text or a List. Trace the input type, keep date calculations as Date values, and decide whether an automation should clear or preserve its target.
A date difference and an inclusive calendar count answer different questions. Check the inputs, range endpoints and clock before adding one to dateBetween.
Compare the missing result with the checks in each published guide before changing the source data.
Use the published access guides to check what the client can reach and which sharing rule applies.
Follow the event from its trigger to the action you expected, then check the limits described in the guide.