Sign in to join the conversation:
Hello Community!
My question is quite simple. (I hope).
How can I display the last value of a column? I tried to use the formula = INDEX, but I could not read the last number automatically.
Thanks!
=Index(NPS:NPS;count(NPS:NPS)+2)
The +2 is the empty cells at the top.
Worked!Thanks Luke!
Hello all, I am looking for some help with a formula. I'm super close to getting it but can't figure out the last piece. Goal: I have a sheet tracking task completion and want to calculate, month by month, the percentage of tasks completed for each person. Setup: Level 1 rows = person’s name (owner of tasks) Level 2 rows =…
Hello - I have a formula that I use to find the next upcoming task showing as "Not Started" and assigned to "Joe Smith." It has worked seamlessly for months and now all of a sudden is returning an incorrect value and I am totally stumped as to why. Here is the formula: =INDEX([Task Name]:[Task Name],…
the "generate documents" function is not working, it keeps hanging in the backgound job. Same with trying to download, also keeps hanging. This is accross multiple sheets, the documents are not generated. Anyone who can assist?`
