Hello guys,
I am quite in a dilemma of getting the name of the sheetname in a formula tool. My formula seems correct although it gives me a null value. Maybe becauese the workdate2 is null? But I have use the date tool and nothing happen. Can someone to please please help me solve this problem. I can't locate what went missing. Please see screenshots below.
Thanks,
Kamen
Solved! Go to Solution.
Hey @KamenRider,
What does your Work Date column look like?
@KamenRider select this column in your date time tool configuration
You need to tell it the format your work date column is currently in.
Hi @IraWatt
I already did it however, results does not make the sheet name visible. I can't find the reason. See screenshot below.
Please advised.
Kamen
@KamenRider you have selected MM/dd/yyyy your data and the one I selected is in the format MM-dd-yyyy. It is dashes - not forward slashes /
HI @IraWatt
I have changed the format of the date and nothing happens. It does not resolve the issue. Please help me with this. Please see screenshots.
Hoping to hear from you.
Thanks,
Kamen
@KamenRider, your date is incorrect there is no Feb 29 2022 try changing it to Feb 28, 2022, then try your method or try this.
I hope this helps!
Thanks!
Nice @grazitti_sapna ,
My dilemma has been resolved. I was not able to catch that thoughts for Feb 29. Thank you so much.
@KamenRider, you're welcome.