-
Re: How to remove the unnecessary commas?
Hello @Ashley Klaers Just reference or adjust the column containing the employee names so it doesn't pick up all the information =JOIN(COLLECT([Inspected Employee's Name 1]@row +... + [Inspected Empl…1 · -
Re: Increasing number when meets same value autonumber, possible formula
Hello @Cybsss To be able to achieve the desired SN format: Add an Auto-Number Column (System Column): Create an Auto-Number Column (RowID). This column will automatically generate a unique number for…1 · -
Re: Help with CountIfs formula
Hello @Hawk23 Please try this Hope this helps! che1 · -
Re: 'Project Category' column in 'Project Intake Sheet' of "PMO Template"
Hello @smartnewbie It seems the 'Project Category' column isn't entirely affecting the dashboard, but there's potential in how we utilize it. I've adapted it as the 'Project Type' for the constructio…1 · -
Re: How can I total actual hours complete by who it is assigned to?
Hello @EJ End Use SUMIFS function to sum values based on multiple criteria. Hope this helps!🙂 che1 ·