I don’t know if some of you noticed during the block party but Angad showed an extremely useful formula that I would like to replicate - Link to replay - Starting at 26:24.
You can extract the content of a cell based on a specific key (AI in his case). I would like to apply the same to my status report where my use case would be:
- Every time I use a new item I put the date in this format dd.mm
- Today’s date is formatted the same way dd.mm
- Today’s note compare today’s date to the cell content and only extract the line that correspond to it.
Is it something that we can achieve? I did not manage to replicate the same behaviour.
Thank you for your help,