DKazatsky ✭✭✭✭

Overview

Overview

Roles	Member
Badges	8

About Me

About Me

Not much happening here, yet.

Analytics

43

Posts

92

Visits

161

Points

Jan 11, 2023

Join Date

Mar 10, 2023

Last Active

Reactions

• Insightful 2

  2
• Vote Up 2

  2
• Awesome 5

  5

• Activity
• Discussions2
• Comments41

• Re: Keep the text in a cell if is not blank but if it's blank then add "N/A"

  DKazatsky

  02/01/23
  Hi @EmilyEchevarria This can be done with a Workflow as such... Where I have "Primary Column", you use the appropriate column. You can change "Run workflow" to best suit your need…
  1 ·

• Re: What wrong with this IF OR Loop statement

  DKazatsky

  03/03/23
  Hi @tprakash2211 You are missing a paren after your 3rd "OR". =IF(OR([Site]@row= "Kelowna", [Site]@row="Vancouver", [Site]@row="Victoria"), "British Colum…
  1 ·

• Re: Sheet Summary with SUMIF

  DKazatsky

  02/13/23
  Hi @Dixon You need to use SUMIFS if using multiple criteria. Try this: =SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], "Software", [Month Number]:[Month Number], 2) Hope this …
  1 ·

• Re: RYG Status w/ Date and Checkbox

  DKazatsky

  02/10/23
  Hi @Adrienne Strong Try this one: =IF(NOT(ISBLANK([Submitted Date]@row)), "Green", IF(ISBLANK([Due Date]@row), "Gray", IF([Due Date]@row <= TODAY(), "Red", IF(AND([Du…
  1 ·

• Re: #Incorrect Argument Set with =COUNTIFS

  DKazatsky

  01/11/23
  Update: It looks like the reference was the issue when I cut/paste the formula. Even thought the same reference was being used in the current sheet, when I reinitialized the reference, everything wor…
  1 ·