#function day

[mtgomes]

SharePoint: ISNA Function

Welcome to Function Day. This week we focus on SharePoint’s “ISNA” Function. One new function, every week, with tips, tricks, and stuff you should know. #sharepoint #ISNA

Following the “IS” functions theme, we have the ISNA function. This checks for the “#N/A,” an error that we know all too well in Excel. These functions return TRUE or FALSE, depending on the value that they are checking. Usage It follows a simple pattern. Value Example: Col1 has the value "#N/A" ISNA([Col1]) will return: TRUE You don’t necessarily need to check for errors, but you…

View On WordPress

[mtgomes]

Power Automate: substring Function

Welcome to Function Day. This week we focus on Power Automate's “substring” Function. One new function, every week, with tips, tricks, and stuff you should know. #powerautomate #substring #tip

The substring function is widely popular and widely used. We have the need all the time to parse the string to get sections of it. Think of, for example, a name where you want to extract the first and last name to store it in the database, or a full URL where you want to extract the domain for later reference. There are many useful things you can do with this function, but let’s first see how it…

View On WordPress

[mtgomes]

SharePoint: ISNUMBER Function

NEW POST: Welcome to Function Day. This week we'll explore Microsoft's SharePoint List Function "ISNUMBER" and give you tips and tricks on how to use it efficiently. #sharepoint #isnumber #function

The “ISNUMBER” function relates to a group of functions called the “IS” functions. These validate if the contents are of a specific type or returned something, like the “ISERROR” or “ISBLANK” functions. Usage It follows a simple pattern. Value to check Example: =ISNUMBER(3) will return "TRUE" Let’s see what happens when we try a string that is a number: =ISNUMBER("3") will…

View On WordPress