Dynamic formula/select help

Question

Hi everyone.

Could someone help me with a challenge I'm facing...

My data has many fields corresponding to months. It also has a [Year] and a [Month] field which relates to when the report was generated.

I'd like to create a new [This Month] field that takes the [year] and [month], and returns the correct field.

This needs to be dynamic as the Year and Month change and I don't want to re-write my formula each month.

I've included as screenshot of the sample data, and the [This Month] field i'd like to create.

Many thanks,

🙂

2021-01-06a.PNG

fmvizcaino · Answer

Hi @TSP ,

Sure. That is why I'm using the left function before. Left(datetimetoday(),7) equals to yyyy-mm.

See example attached.

Best,

Fernando V.

2021-01-05 Dynamic formula-select help.yxmd

pedrodrfaria · Answer

Hi @TSP

See attached below for the workflow using a transpose and join logic:

Pedro.

New Workflow1.yxmd

TSP · Answer

Thanks @fmvizcaino , however the month in question is specified by the [Year] and [Month] fields rather than relating to DateTimeToday, if that makes sense?