Best Of
Re: Control Center Profile Data Not Populating
It definitely seems like you have been hard at work! For the one date pull: I self built our control center solution and attended the control center build instructor led course. The single date provision was something that was noted during the class.
I would still think that we should be able to get you to a better solution than this, as there is still so much self linked information. I would be happy to do a virtual call, where we can explore your sheets / solutions and see if we can't get this in better shape for you. If you want to schedule something, you can book on my calendar here: https://calendly.com/colleenpatterson/tcx-intro-call That link will schedule a 30 minute virtual session.
Re: Control Center Profile Data Not Populating
Thanks, @Colleen Patterson!
I have a Control Center Pro Desk session on Thursday. If they can't help me finish this build out, I'll certainly reach out :)
Re: Control Center Profile Data Not Populating
@Kayla Q Definitely! Hope the meeting on Thursday goes well.
Re: Control Center Profile Data Not Populating
@Kayla Q That is great to know, and I appreciate you follow up with me! I'll update my template and see what returns.
Re: Control Center Profile Data Not Populating
Note to future self - This error is likely caused by 1) locked columns, 2) columns converted to function, or 3) enabled dependencies. Control Center is unhappy if any columns are locked.
Re: Control Center Profile Data Not Populating
One more note on predecessors and dependencies: You can have them enabled, but you can't have predecessors and durations pre-populated in your template - otherwise Control Center freaks out.
Re: Control Center Profile Data Not Populating
Also, Control Center is only unhappy if any system-generated columns are locked. You can lock columns and Control Center will still work. However, if a column has been converted to a function column, Control Center will not function.
Re: NEW! Dashboard Builder Enhancements
This is great! Now if we could just have a Flow Chart Wiget!
Marlana K.
Re: Reorder Favorites and Pinned Recents
+1
I came to submit this idea and found this so upvoting. I would like to see Favorites Grouped by Workspace/Folder and then sorted within.
Re: Subtracting Dates Issue
Looks like there needs to be a closing bracket for the YEAR function? Maybe try this?
=IF(YEAR([Last Hire Date]@row) = "2024", (([Proration Date Reference]@row - [Last Hire Date]@row)/365), "1")
Note: you don't need the extra brackets around the 'If True' portion. The following should also work:
=IF(YEAR([Last Hire Date]@row) = "2024", ([Proration Date Reference]@row - [Last Hire Date]@row)/365, "1")
Jason Albrecht
