I am trying to have a formula in a cell that will total "1" if the Assigned to Column is a certain name, and the Status Column is QA, or fielded. 

This is what I have and I need Help please..... I know it is so wrong but I am lost on how to correct it.



I've been importing data from Toggl ( using Zapier ( to SmartSheet. The date/times are recorded in Toggl in UTC, and I'm trying to convert this to HST (i.e. -10 hrs). My settings are for HST.

The UTC format: 2019-03-15T02:43:21+00:00 

I've tried several suggestions in other