Best Of
Re: Form Access Message
Thanks @Vivien Chong, I agree with this approach and tried to locate and format it so it's as easily visible as possible. Not perfect, but perhaps the best I can do!
electrichead
Re: Can you setup an automation that pulls from an "email address" column that's not a contact column?
@Kristen Christman It has to be a contact type column for the automation to read the email address provided upon submittal. You do not need to have a full list of contacts added.
Razetto
Re: Business plan. Limitations on the number of dashboard widgets. No access to Team workload tracking
It sounds like your account may be associated with multiple plans, and that your default plan is defaulting to the Pro Plan, which has a limit of Widgets.
You can check what your default plan is by clicking on your account icon in the bottom-right of your account, then selecting Personal Settings and then going to Plan Info.
This Help Article has more information:
Let me know if this helped!
Cheers,
Genevieve
Genevieve P.
Re: Is there a formula to update the status based off the % complete?
Thank you that worked!
Deb Wardlaw
Re: Updating a Parent Row Based on Children's Status
Hi @Tony Fronza,
See if this works out better for you.
=IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(COUNTIF(CHILDREN(), "Complete") + COUNTIF(CHILDREN(), "Canceled") = COUNT(CHILDREN()), "Complete", "Not Started"))
Notes:
- This can only be put into the parent row, cannot be a column formula
- If any of the [RFP Status]@row cells are blank, this will not work as the COUNT formula only includes cells with values
Hope this helps,
Dave
DKazatsky2
Re: Updating a Parent Row Based on Children's Status
@DKazatsky2 never mind! There was an issue with the sheet's formatting. It's working now! Thanks again.
Tony Fronza
Re: Formula for numbering rows based on specific conditions
Hi @Brooks,
This is happening because the COLLECT statement is including the row with "Feedback" as a type, we need to ensure the COLLECT only has the "Focus Group Volunteer".
Try this one.
=IF(AND(Internal@row = "No", Type@row = "Focus Group Volunteer"), IFERROR(RANKEQ(Number@row, COLLECT(Number:Number, Type:Type, "Focus Group Volunteer", Internal:Internal, "No", [Patron Type]:[Patron Type], OR(@cell = "Faculty", @cell = "Instructor", @cell = "Visiting Scholor")), 1), ""))
Dave
DKazatsky2
Re: Is there a way to populate the successors names in a cell based on successors column?
@sweta22 Yes you can do that!
I went ahead and made a video to answer you question. Let me know if that works for you!
Darren Mullen
Re: Help with Join collect multi criteria error
Hi @NCookBT83,
I think your syntax is off. It is correct in the formula you say is working, but when you added the second criteria, it looks like you reversed things in the COLLECT portion.
See if this works.
=IFERROR(JOIN(COLLECT({Sheet - QER Assembly}, {Sheet - QER Client ID FX}, [Client Number]@row, {Sheet - QER Workflow Des}, OR(@cell = "Year End Planning", @cell = "Year-End Planning")), ", "), " ")
*Untested
Hope this helps,
Dave
DKazatsky2
Re: Community Corner Newsletter [January 2025]
Hi @skipper23,
If they have a Community account, they'll receive a notification in Community, and via email as soon as we publish the newsletter each month. That would be the easiest way to keep up with our updates. 😄
Rebeca S.