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
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
The data on the sheets looks something like below - I figured out the types of charts I would need on top of the data
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
Once the charts are done I can start plugging them into the Sheetgo dashboard
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
So the dashboard looks neat and helps me visualize my Wisesheet template data!
