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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thanks you Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives