Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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, We are using the same automations across countless sheets, and they have been working reliably for years. They are set up correctly, and no changes have been made to them. However, they stopped triggering yesterday. The automations are very simple and are triggered by cell changes. For example, if we enter "Done" in…
I am trying to create a project as a child under the parent blueprint to maintain a hierarchical structure within the workspace. However, instead of being created under the parent folder, the projects are being provisioned as separate folders at the same level.
Good afternoon. I am trying to create an update request to have contacts in a cell complete a voting task. I have been asking the AI what the issue is and it had good suggestions, everything it suggests is occurring on the sheet. The update request is to trigger when the "Launch update request" changes to checked. It will…
