Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,445 questions
I created a Microsoft List using an existing Excel file, but the formulas didn't transfer over. How can I put the same formula in the list column?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
dboze
1
Reputation point
Here is the formula I want to have in one of the columns:
=IFS(ISNUMBER(SEARCH("content",F4)),"name",ISNUMBER(SEARCH("content2",F4)),"name2",ISNUMBER(SEARCH("content3",F4)),"name3",ISNUMBER(SEARCH("content4",F4)),"name4", ISNUMBER(SEARCH("content5",F4)),"name5")
(The "content" and "name" in the above is changed from the original formula I have. In my excel file, content = internal document number ex. ABC21-AA and name = actual name ex. Jane Doe)
Is it possible to have this type of formula in Microsoft Lists? I tried to put it in there, but I got a syntax error. I pasted the formula, and put in the column name I need the formula to reference in for the cell number ex. F4, F5, etc. was changed to [column name]
{count} votes
-
Deva-MSFT 2,256 Reputation points Microsoft Employee2021-02-06T18:12:01.95+00:00 Do you use Microsoft Graph API to perform the above or just using Microsoft Excel?
-
dboze 1 Reputation point
2021-02-08T13:09:30.223+00:00 I used the import function for Excel in Microsoft Lists.
-
dboze 1 Reputation point
2021-02-12T16:26:27.63+00:00 Any update on this?
Sign in to comment