khankoff’s Profile

Community member since March 2019

points
178

3

I have a formula that looks like this:

=SUMIF([Request Status]:[Request Status], "5-Complete", [Est Days to Scan]:[Est Days to Scan])

I've noticed that in each of the two columns referenced in my formula, the selection includes 10 rows of blank cells below the last populated cell.  Is this normal?

4

I'm trying to build an IF statement that will change the value in a Status column.  The Status column has three values in the dropdown (Not Started, In Progress, Complete).  I would like to leverage two adjacent Date columns (Scan Started, Scan Completed) to auto-change the values in the Status