Best Of
Re: Variance on time or behind schedule collumn
Hello @Joechaptaylor. Try something like:
=if(Variance@row="","",if(Variance@row>=0,"On Track","Behind Schedule"))
Philip Robbins
Re: Index(Collection formula for dropdown field with multiple entries
This can certainly be done if I understand what you need correctly.
You want to take all selections from the [Blockers] column and output a group or groups based on those selections made.
My suggestion would be a helper sheet that has all blockers listed in one column and their group in another column. Then you would use a JOIN/DISTINCT/COLLECT combo to grab each of the appropriate groups like so:
=JOIN(DISTINCT(COLLECT({Reference Table Groups Column}, {Reference Table Blockers Column}, Has(Blockers@row, @cell))), CHAR(10))
Paul Newcome
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