Welcome!

Future-state request --- Ability to access and edit MS Excel documents directly w/o ha

I believe the request was cut off mid-sentence. Would you mind clarifying further? Perhaps you meant:

Future-state request: Ability to access and edit MS Excel documents directly without having to download them?

Unable to edit formulas
Any one have issues with suddenly not being able to edit formulas? I am admin and owner of the sheet one other admin has access to sheet and no locks have been placed on the cells.
Referencing another Column in the same Row after finding the MIN with Criteria
I am trying to find the next upcoming Date and its associated Task based off what activity is being performed and where it's taking place. The formula I have to find the next upcoming date works perfectly: =MIN(COLLECT({Date}, {Date}, >=TODAY(), {Activity}, ="Activity ", {Area}, ="Area")) My problem is trying to get the…
How to determine the last two lines of a sheet when row is checked
I'm trying to find and number in the Rank column the last two rows that have a status column with a check in the checkbox. I am using the following formula but am getting a #INVALID OPERATION error. =IF(AND(Status@row = 1, [Row #]@row >= LARGE(COLLECT([Row #]:[Row #], Status:Status, 1), 2)), 1, 0) The properties for each…