Best Of
Re: How to collect multiple Successor values?
Hey @Jason.Darr
Yes, I believe you're correct - if there are multiple values in the cell then the formula won't be able to search for the rows individually to return the successors.
We can add that information to your formula, try this:
=IF(FIND(",", Successor@row) > 0, "Multiple", IF(Successor@row = "", "None", JOIN(COLLECT([Assigned To]:[Assigned To], Row:Row, HAS(Successor@row, @cell)), CHAR(10))))
Cheers,
Genevieve
Genevieve P.
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