Getting the Sheetname Visible

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

Workflow

Output

Tips and Tricks

Custom Tools

Date Time

Common Use Cases

Dynamic Processing

Join

Expression

Data Investigation

Documentation

Behavior Analysis

Accepted answers

@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!

All comments

Hey @KamenRider,

What does your Work Date column look like?

The work date column look like this.

Hope to hear from you.

Thanks,

Kamen

@KamenRider select this column in your date time tool configuration

You need to tell it the format your work date column is currently in.

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 /

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

Quick Links

Tags

This months top contributors