Hi community! Looking for some guidance please! :) I need a column capturing the number of specific job roles associated with project. e.g. Job Roles ---- Product Manager Delivery Manager Software Eng…
Hi, My sheet is adding in new rows based on my list of dropdown selections. I added in some suppliers in a column which we may use in the future but currently do not have rows in my sheet. However, th…
Hi and Happy New Year, Hope all is going well for you. In the Project Intake Sheet, I'm using the Sheet Summary to calculate metrics for reporting. On this particular formula, I keep getting #UNPARSAB…
I have a column with the following options for drop down fields: NA, Not Started, Required, Drafted, Posted What formula can I use to show me % complete (posted) without taking into account the NAs?
Whenever a dropdown is set to allow for multiple values in the field, all values are "searchable" so that you can type in any portion of the selection and it'll limit what you can see to where that st…
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is wher…
Hello. I'm looking for some feedback on a control center process we've built. We have an intake sheet with standard and optional department assets depending on intake data. To mark which assets we nee…