Community

5

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.

=IF(STATUS672 = "QA" OR(STATUS672 =

1

I've been importing data from Toggl (toggl.com) using Zapier (zapier.com) 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