SOLVED
Help needed to auto create monthly columns from quarterly columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
charlenemx1022
6 - Meteoroid
‎11-06-2024
01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am looking for an easier way to create 12 new monthly amount columns from 4 quarterly amount quarters (equally division) without having to manually using 12 formula tools. Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
- Workflow
6 REPLIES 6
binuacs
21 - Polaris
‎11-06-2024
01:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@charlenemx1022 can you provide more information or sample input and output for better understanding?
‎11-06-2024
01:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry about that. Yes. I have Q1,Q2,Q3 and Q4 columns and I would like to create 12 new monthly columns for Jan-Dec with the monthly amount (Quarter amount /3) without having to use 12 formula tools. Thanks!
binuacs
21 - Polaris
‎11-06-2024
01:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@charlenemx1022 one way of doing this
‎11-06-2024
01:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks so much!
‎11-06-2024
01:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is that a reason why you used a Dynamic Select instead of a Select?
binuacs
21 - Polaris
‎11-06-2024
03:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It is more dynamic than select tool
