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!
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
