Best Of
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 :)
Kayla Q
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.
Kayla Q
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.
Kayla Q
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.
Kayla Q
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.
Steve_Mitchell
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
Re: Default a value in dropdown list??
You can, in essence. If you are using a form to populate the dropdown list you can put that value in a hidden field, and then change it after the form is submitted.
If you're talking about when you add a new row - right from in smartsheet? Maybe not. When I create my templates for new projects in our project sheet I have the template rows already set at my default value before copying them into my sheet. So it kind of depends on how you are using them.
Mike Wilday