Community

3

This is my formula and it works only up to the line 2.  Starting with line 3, it will only work if the previous line(s) get reset to 0%.  I need the [Comments]1 to update as each [%Complete] status =1 with the next row Task and Assigned To.

=IF([% Complete]1 = 0, [Task Name]2 + ", " + [Assigned

1

I feel silly, but I'm stumped.  I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE.  What am I doing wrong?

=COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker

1

I have a form that managers will fill out stating who participated in a project and what percent of the project they completed. I have a column that auto calculates the total percent (with conditional formatting) to help with the final review of the information. I would like the total percent field