Hi,
I have been looking at smart spreadsheets and trying to understand if its possible to extract calcs from certain cells into our monday boards.
Example:
We have a cost calculation sheet.
- You enter the cost of a job and the VAT rate
- You then select how many payments will be made
The sheet then generates how much is due at each payment stage inc VAT and any other fees. This is shown as each amount due in a different cell e.g.
Payment 1 - £550
Payment 2- £1000
Payment 3 - £600
Is there a way to only extract those values into our board and not include any of the calc details? Can I use my own current format as below? I work with an older team and change isn’t always the best. FYI, we populate the white cells and the calcs are formulated in the blue cells.
