Kblake
Kblake
Reactions
Discussions
- Based on what I read about HAS Function in the Formula Basics (HAS Function | Smartsheet Learning Center) I should be able to use HAS with COUNTIFS. When I try to use it in a sheet, I receive the erro…
- Currently I have two COUNTIF formulas in two different cells, then I am using a 3rd cell to add them together. I am looking for a way to combine the formulas and have everything calculated in one cell…
- Response to Pro Desk 07270893 session. I have a form set up that creates an entry into a sheet. I am looking for when the form creates the entry into the sheet, to trigger a 2nd sheet (different sheet…
- What I am trying to do: I am trying to write a formula that counts the projects that are in any of the following Stage of Project: Kick-off & Requirements Gathering, Test Setup, UAT, or Deployment AND…
- I have been trying to figure out where the issue(s) with my formula is awhile. I have tried to break the formula down in sections too, that didn't help. Is anyone able to help with my formula? What tr…
