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
I have a to do list with parent tasks and children tasks. I have a status column with a dropdown menu with the options “Not started,” “In process,” and “Completed.” I want to have a formula that auto-populates the parent task with the status based on the children tasks. Here is the logic that I want the formula to use: If…
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
Hi, I am trying to get a column that provides the Date (easy with Record a Date) but I need the TIME as well. Most of my tables I just use the right function on the Modified Date because the only thing updating those tables are automations or data imports. But a few tables have automations, data imports, and manual inputs.…
