Text Functions

Last edited 80 days ago by MyCondy

Text inside "<>" character should be replaced by your real data.

Left(User().FullName, 1) & Mid(User().FullName,Find(" ", User().FullName) + 1,1)

Mid(Last(<TABLE>).Title,Len(Last(<TABLE>).Title) -1)

LastN(ForAll(

SortByColumns(Distinct(AddColumns(Filter(<TABLE>,Year = Year(Today())),"_months",Month(<TABLE COLUMN>)),_months),"Value",SortOrder.Ascending),

{_months: Value,

totalHours: Sum(Filter(<TABLE>, Month(<TABLE COLUMN>) = Value),Hours)

}

),6)

Concat(Filter(<GALLERY>.AllItems,sel_emp_check.Value = true),<COLUMN NAME>,";"))

⁠

← Custom Functions⁠

⁠

Date Functions →⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.