So I was exploring the list of wisesheets templates and came across the discounted cash flow (DCF) template
The template is pretty neat so i thought of connecting it to a Sheetgo dashboard - to make it look something like below - I will try and walk you through the steps
![](https://i.imgur.com/oELnWUKh.png)
First create the workflow - I kept it simple where I have the template sheet linked to a Sheetgo form - this is being used to input the particular company whose performance I want to analyze - the workflow looks something like this
![](https://i.imgur.com/D0xfzpfh.png)
The data on the sheets looks something like below - I figured out the types of charts I would need on top of the data
![](https://i.imgur.com/l327xP8h.png)
After setting up some formulas I came up with a couple of charts on another tab of the sheet - this is the preparation to plug it into the Sheetgo dashboard
![](https://i.imgur.com/EtX9V8Th.png)
Once the charts are done I can start plugging them into the Sheetgo dashboard
![](https://i.imgur.com/rFEbT8Uh.png)
The dark theme looks pretty neat as well
The only bug I noticed was the years on the x axis labels came up in dollars - I am trying to figure out a way to solve that on the sheet
![](https://i.imgur.com/PWDDpW7h.png)
So the dashboard looks neat and helps me visualize my Wisesheet template data!