How to Import Profit & Loss Template in Smartsheet
I can download the Profit & Loss template from SmartSheet but cannot import it to my Smatrsheet Account (it loses its trend chart etc).
Have tried to look this P&L sheet in teh solution center but could not find it. It is only showing up at this link How to Use Profit and Loss Templates | Smartsheet
Best Answers
-
Hi @Anuraag
You're right, that template is actually an Excel template example so it will have different functionality when imported in to Smartsheet. The trend chart would need to be created as a Chart Widget in a Smartsheet Dashboard, instead of being in a sheet.
There's a Budget Management template set (here) that shows how you can use Sheet and Report data in a Dashboard. There's also an Income Statement template in the Solution Center that goes through profit, if that helps.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks you Genevieve
Answers
-
Hi @Anuraag
You're right, that template is actually an Excel template example so it will have different functionality when imported in to Smartsheet. The trend chart would need to be created as a Chart Widget in a Smartsheet Dashboard, instead of being in a sheet.
There's a Budget Management template set (here) that shows how you can use Sheet and Report data in a Dashboard. There's also an Income Statement template in the Solution Center that goes through profit, if that helps.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks you Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives