Sign in to join the conversation:
Hello,
I have a column that has the quarter, like Q1, Q2, Q3, and Q4. Now I'm trying to show the last month of that quarter on a new column. I tried to use IF([Refresh Eligible Quarter]@row) = Q1, "March") but it doesn't work.
Any idea?
Thanks!
Put Q1 in quotes in your formula.
=IF([Refresh Eligible Quarter]@row) = "Q1", "March")
Hi, thank you! When I do that I get #UNPARSEABLE for some reason.
Could you have accidentally included the comma or equals sign in the quotes?
Can you provide a screenshot of the formula in the sheet?
Sure, I have attached it.
Remove the parenthesis after @row and then it should work.
Did it?
Best,
Andrée
What a foolish mistake!!!
Thank you
Easy to miss! We've all been there and will be again
We have a sheet to help track when notary renewals are upcoming for staff and its a fairly simple process. We have a date column that lists the expiration date, a helper column that turns that into a total day count, status, and if an application was recvied. The trigger for this would be when that Days Until Expiration…
Hi Team, I have 2 columns in the sheet One is Month and the values are Jan, Feb, Mar,…. Dec Another column is $ value against each of the month. All I need is that based on current date/month, the sum value for Previous month and Current Month sums up. All I need in a separate cell value to just sum up for Current and…
This discussion was created from comments split from: Index Match with multiple results?.
