MonthName problem

[sayanpwc]

Hi guyz,

Facing a problem with my monthname field (MONTHS).

My requirement is to when activate the sheet this MONTHS field should always be selected < current month.

For ex: if current month is May, value in MONTHS field should be selected from Jan,Feb,Mar,Apr.

The values in MONTHS fields are like January,February,March ....

I dont have any numeric field corresponding to this MONTHS field. without doing anything in the script end can we achieve this in trigger?

How can I do that??  Please assist. It is urgent,

[Miguel_Angel_Baeyens]

Fine. See attached with the expression I proposed above.

You can save the Concat() function because you know exactly how the values look like and which months need to be included in each case. And also you can save all the nested If()s, that's what the Pick() function does.