0

Hi all,

 

I am having trouble putting together a formula and I am hoping someone here can guide me in the right direction.

 

We have a sheet that we enter payments we receive from our customers. That sheet has the customer name, check date, deposit date and amount etc.

 

I am looking to create a

1

I am trying to use the contains formula within a SUMIF (see below).  This does not seem to work and I can not figure out why.  It seems as though all the examples that are provided, CONTAIN is only used within IF formulas.  Is this the case?

 

My formula:

=SUMIFS({Employee Tasks Range 1}, {Employee

3

Hello,

Is there any way to extract the Cell history to calculate formulas.

What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure