, Looking for your assistance in how to create a formula that does the following: IF cell = 2023 or 2024, then Sumifs (based on the criteria i selected), otherwise, Sumifs (b... rachel Steel Contributor Apr 04, 2024 Biggy_E I believe there are syntax errors in your formula. In ...
Ifnullit will will be taken actual number of columns for each file. However, you shall to adjust combining of the table in the resulting table = Csv.Document(Parameter1,[Delimiter=",", Columns=null, Encoding=65001, QuoteStyle=QuoteStyle.None]) The rest became quite messy, as i had to pa...
it seems like you want to input a single activity number for each task. When multiple employees are assigned to one task, only the first row will contain the activity number, description, location/notes and unit. If this is correct, I'm ...