Hi Smartsheet Community,
I’m running into #INVALID errors in a resource management report and can’t seem to track down the root cause. I’ve attached two visuals for context:
- A screenshot of the report showing which team members are affected (
#INVALID appears across all months for some users like Jerritt and Danny). - A data flow diagram showing how the report is built—from data transformation to utilization calculations and final report grouping.
Context:
- The data is transformed to show Remaining Capacity per person per month (e.g., March, April, May).
- Remaining Capacity * (1 - Utilization)
- The final automated report groups by team member, then month, and refreshes daily at 1PM.
What I’ve Tried:
- Refreshed the report multiple times
- Verified filters and data completeness in source sheets
- Checked formulas but couldn't find any broken references
Issue:
Some rows display #INVALID across all calculated columns even though:
- The same formulas work for other team members
- The source data seems intact
- The users are not excluded by filters
What are the likely causes of this #INVALID error in this type of setup?
Attached are both the reported error as well as the data map flow.
