Excel

[vijaylnyadav]

Hi All,

I want a workflow which creates an output with current data and time in output name.

Schema for Output: 

for eg.

Output_05012021_1330.xlsx

The output has different sheet  names which I am taking from one of the fields from data for e.g. Maths, English, Science, History, Geography.

So sheet name must not be changed.

Please suggest me some workflow.

[Emil_Kos]

Hi,

I am not sure if I got all the requirements correctly but for my understanding, you already use this option:

If that is the case you should use also datetimenow formula somewhere in the workflow and you should be able to make it work. 

[vijaylnyadav]

@Emil_Kos  yes I am using the same options but it is updating the sheets and that is fine but I want to update the file name according to the system time and date. 

and I am not using file name as you mentioned in a pic, I am using for eg subject instead of file name for updating several sheets.

[Emil_Kos]

Hi,

I have prepared the workflow for you.

It is using both the column name + System date time in order to save the output file.

The name of the outputs: