Hello @Crabe
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?
Based on the screenshot below, I am trying to write a formula that will pull in the reason for change on the row where " most recent change" is checked. Thoughts on the best formula? I've tried: =IF([Most Recent Change]:[Most Recent Change] = 1, [Reason for Change]:[Reason for Change] , "") Is there something I can do with…
I'm trying to seta formula for the health of the project's tasks based on certain conditions. This is the formula: =IF(OR(AND(Status@row <> "Complete", [End Date]@row < TODAY()), AND(Status@row = "In Progress", VALUE([% Complete]@row ) < 0.3, NETDAYS(TODAY(), [End Date]@row ) <= 30), AND(Status@row = "Not Started", [Start…
I'm using a form entry (into an Intake Sheet) in which someone can select multiple locations for the same Initiative. I'm looking to copy the row to a different Master sheet, but would like to have the same row copied multiple times, once per location selected. Intake Sheet: Desired Result in Master Sheet: Basically, I…
