There are several common reasons why formula columns might not display their expected values:
1. You may need to refresh your browser using Cmd/Ctrl + Shift + R to resolve "Error evaluating formula" issues.
2. If you're referencing columns from another table, you'll need to re-run the company row in the people table or force run the entire column to see the new values.
3. The formula might be assuming data exists in every row when it doesn't. Adding conditional logic (like "if {{response}} exists...") can prevent errors when referenced data is missing.
If these solutions don't work, try creating a fresh column with the same formula to see if that resolves the issue.
If your formula columns aren't displaying their expected values, try these solutions:
1. Perform a hard refresh of your browser:
• Windows: Ctrl + Shift + R
• Mac: Cmd + Shift + R
This often resolves display issues with formulas.
1. If the formula depends on data from another column, you might need to force run the column:
• Right-click on the column
• Hover over "Run Column" > "Force Run All Rows"
2. Check if there are dependencies between columns that might be causing the issue. Ensure your formula only runs when the required data is present.
If these steps don't resolve the issue, please request human assistance for more specific troubleshooting based on your screenshots.
.png){kind=logo}
