Displaying Payments on a date with Calendar view ?
I have 4 columns with Payment and 4 with date I want to associate these payments on a calendar.
Like this is going to be my format.
Answers
-
Hi Karan,
You might have to rethink how you are structuring your sheet. As the primary column row is what shows up as an event on the calendar and can only be associated with a single date or date range.
If you can structure each payment type into a single row you could then display each date on the calendar with the information you desire. Even more fun, You could create a sheet for each client and then use a report to show all clients on a single calendar.
Hope this helps.
best,
Brad
MVP OPS
best,
Brad
www.MVPOPS.com
-
Hi @Karan Buga
I agree with Brad - the Calendar View in a sheet takes one set of dates (either a Start and End date in the row or just one date column) and the Primary column to create the view.
If you have multiple dates in the same row, you'll need to either break out those dates down multiple rows or create multiple Reports off of this one sheet to show your different columns. You could have 4 Reports - one per date column - and then embed all of these in a Dashboard, however your Payment would be hidden behind the Primary Column text (you'd have to click on the event to see more).
See: Calendar View
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!