Sign in to join the conversation:
Hi,
I am trying to do a count for a field with 3 criteria. I want to do COUNTIFS( A = "x", B = "y", and C = "Z"). Is there a way to achieve this as COUNTIFS only allows you to do this with 2 criterion?
Countifs will allow you to use as many criterion as you want. just keep going with the same format.
range, criteria, range, criteria, range, criteria and so on
the only requirement is that the ranges need to all be the same size.
Good afternoon Smartsheet Fam, I'm trying to create an index formula across 4 sheets to pull into a single sheet. The formula I have tried is: =IFERROR(INDEX({AHM.Client}, MATCH([CU Project ID]@row, {AHMPlan.CUProjectID}, 0)), INDEX({ahmne.client}, MATCH([CU Project ID]@row, {ahmne.cuprojid}, 0)), INDEX({ahmse.client},…
I’m trying to set up a metrics sheet that will feed into a dashboard to show a rolling total over time, but I don’t want future months to display any data. For example, a user will enter values in the right-hand column, and I have a formula that calculates a rolling total in the green column. The green column is what I…
Hello, I am looking to create a summary formula that calculates the projects completed within a given month. From the screenshot, I need a formula that evaluated the 'Status = Posted Live' AND the Actual Completion Date within March 2026. I've been playing with the CountIf formula, but I can't get it to work! Any ideas?
