Forum Discussion
Solved
Create worksheet
Hi I wonder is someone can help me I starting dog grooming and need toncreate a daily worksheet for every day included in that sheet I need to enter lots of info then I would like to create monthly w...
- Ho it's exel for windows
Perhaps we may combine all togeteher
=LET(
tbl_rows, FILTER(
tblVisits,
(tblVisits[Start Date-time] >= $C$1) *
(tblVisits[Start Date-time] < ($C$1 + 1)) *
(tblVisits[Canceled] = 0),
NA()
),
desired_array, SORT(
CHOOSECOLS(tbl_rows, 2, 3, 4, 5, 6, 8, 9, 11),
1
),
getDog, LAMBDA(visit,
LET(
dog, XLOOKUP(
INDEX(visit, 1, 2) & INDEX(visit, 1, 3),
tblDogs[Owner Name] & tblDogs[Dog],
CHOOSECOLS(tblDogs[[Breed]:[Other Notes]], 1,3,6,7,8 ),
""),
dogClean, SUBSTITUTE(dog, "", ""),
HSTACK( visit, dogClean )
)
),
REDUCE(
{"Start","Owner Name","Dog","Wash","Cut","Exp. Dur'n","Exp. Fee","Visit Notes","Breed","Age","Phys. Cond'n","Behavior","Other Notes"},
BYROW(desired_array, LAMBDA(v, LAMBDA(getDog(v))) ),
LAMBDA(a,v, VSTACK(a,v()))
)
)
see second Daily sheet.
I have hand written what I need I have taken photo of it but how do I attach it to this ?
If you mean to attach the file and you don't have this option
put the file on OneDrive, or Google Drive, whatever, share it with everyone and post the link on the file.
If to share screenshot, copy the image (Ctrl+C), click on this icon editing the post
click on grey are in opened window, paste image by Ctrl+V, Ok.
I have sent link
Sorry, I could help with this or that formula but not with design of the project from scratch. Not enough time. Perhaps someone else could jump in.