I have a dashboard that has a tracker where I want a calculated field column to display a default value initially. Is there an easy way to do this?
Bringing this back to the top. Anyone have suggestions?
Could you please explain the situation in more detail?
It boils down to conditionals really. What’s the trigger to not use the default? Adding a check for that trigger to the calculation itself would display the default if those conditions haven’t been met.
If it’s a default value of A, but we want to show calculated value B if someone enters data in fields B or C, you could add a conditional where the case of C = NULL and D = NULL then A else do the calculation B.