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
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…
