Advanced custom field types in monday.com: Dependency, formula, and location columns
I know monday.com has advanced column types but struggling to understand when to use each. Specifically need help with: - Formula column: What formulas can I use? Any examples? - Dependency column: How does it work with Timeline view? - Location column: Can it integrate with Google Maps? - Link to item: When should I use this vs. subitems?
2 Answers
Here's a breakdown of advanced columns: Formula Column: Supports 20+ functions. Common examples: - `{Days Until Due}` = DAYS({Due Date}, TODAY()) - `{Priority Score}` = ({Urgency} 0.4) + ({Impact} 0.6) - `{Budget Remaining}` = {Total Budget} - SUM({Expenses Subitems}) Dependency Column: Links two items. When Item A depends on Item B, Item B must complete before Item A can start. Works with Timeline to show critical path. Limitation: One-to-one dependencies only. Location Column: Shows address on map (Google Maps integration). Good for: Client visits, event locations, remote team mapping. Not great for precise coordinates. Link to Item vs Subitems: - Link to Item: When items exist in different boards or need many-to-many relationships - Subitems: When items are truly child elements of one parent (tasks under a project) We use Link to Item for cross-board references (client linked to their projects across multiple boards).
Adding to formula tips: You CANNOT reference subitem columns in formula columns. Workaround: Use Rollup column in subitems to aggregate to parent, then reference rollup in formula. Also, formula columns don't auto-update in real-time - there's a 15-minute delay. Don't use for time-sensitive calculations.