Last seen: Jun 10, 2026
The link you get from the Copy link function in teams won't generally work as a file path. You should open the file in Sharepoint and get the link fro...
You probably have a hidden workbook. Test for that before trying to copy: Sub CopyToAllOpen() Dim wb As Workbook Dim sh As Worksheet Set...
You could use something like: =LET(ID,LEFT(Table1[@[Recipe ID & Sequence]],4),IF(ID=LEFT(A1,4),"",Table1[@[Recipe Name]]&" "&ID&":"...
Glad we could help. 🙂
Given that you already had three formula cells to get the parts from the split, just clear those and enter the formula into the first one. Incident...
One way would be to have two queries. The first (let's call it Query1) gets the data from the workbook, then just keeps the top 2 rows. The second ...
Yes, it finds the last match if there is more than one. I looked at the underlying XML for the worksheet.
I suspect it's a precision issue (the stored value for the yellow cell on the first sheet is actually 427.04999999999995 not 427.05). You could try: ...
Just as an alternative: =BYCOL(B1#,LAMBDA(c,SUM(B1:INDEX(c,2))))
My point was merely that the user might not actually send the email, but it would still be flagged with the created date and time. You could amend ...
As the code is written, yes, but it could easily be amended to get the path from somewhere else if it's the same for all attachments. I forgot...
Untested, obviously, but something like this: Option Explicit Sub Email_ChangeNotification() ' Sheet where email template (oft) location is...
If you create a date table, you can then use time intelligence functions. You can create a compounding measure (Compounded Percent) using: =VAR CP...
Also cross-posted here (at least):
Which release channel are you on? If it's something like semi-annual enterprise, it's probably just a feature difference.