Best Of
Re: How do i share so people can edit?
Hi Gareth
I'm afraid a Pro license doesn't allow you to share to free collaborators. All editors on a Pro license also need a license.
See here (captured from Smartsheets Website):
Kind regards
Debbie
Debbie Sawyer
Re: Countifs using greater than w/ date
Glad it's working for you.
There are a few ways to look for a blank date field.
One would be to change the > DATE(2022, 2, 15) to an = "" so that it equals empty quotes.
=COUNTIFS({2021 Tax Return Reconciliation Range 1}, "Person", {2021 Tax Return Reconciliation Range 2}, = "")
Another way is to use the ISBLANK function:
=COUNTIFS({2021 Tax Return Reconciliation Range 1}, "Person", ISBLANK({2021 Tax Return Reconciliation Range 2}))
And a third way is to use the NOT and ISDATE functions:
=COUNTIFS({2021 Tax Return Reconciliation Range 1}, "Person", NOT(ISDATE({2021 Tax Return Reconciliation Range 2})))
Jeff Reisman
Re: Is there a way for @mentioning a user in Update Request comments?
Hey @T. Smith
There is actually a way to @mention users via Update Requests!
Since you're not working in the app itself, you won't be able to use their name to select a contact. Instead, type @ and then the email address in the Comment box. This will send an @mention notification to the email (as long as the email is shared to the sheet).
Cheers,
Genevieve
Genevieve P.
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 :)
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