Sign in to join the conversation:
Duh!! I figured it out. It was simple.
Dennis
Hi Dennis,
Excellent!
Glad to hear that you got it working!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have a sheet that has 20 cells that are dates Due and Done for 10 categories. I have an Overdue Week column that I want to show "Yes" if a Due date is prior to current week. I managed to do that, but once one date leads to a "Yes" it never changes even if the task is completed and marked in the corresponding Done cell.…
Hi folks, I'm struggling with a formula that should be simple. When the formula is this, it works great for one of two Types. The second type pulls the wrong Billing Annual Fee. =IFERROR(INDEX(COLLECT({Billing Annual Fee}, {Segment}, Segment@row, {Billing Ownership}, [Billing Ownership]@row), 1), 0) When I modify the…
Hi everyone, Is there a way to display the attachment name(s) in a column?