khankoff’s Profile

Community member since March 2019



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?


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