Help with formula syntax errors when converting to column formula
Help, please.
I'm struggling to debug this formula in Smartsheets.
The formula actually works, and can be copy/ pasted with success. However, I'm getting this error message "The column formula syntax isn't quite right" when trying to convert the cell to column formula. Please help. I can't figure this out on my own. Thanks in advance for the attention and support.
Here is my formula:
=IF(AND([BRM Approved]1 = "No, denied.", [HCL Approved]1 = "No"), "No TAS Needed", IF(NOT(ISBLANK([HCL Request No (i.e. HCA00000)]@row)), "TAS Acquired", IF(ISBLANK([HCL Request No (i.e. HCA00000)]1), "TAS Needed")))
Best Answer
-
Hi @Davey G,
The reason you are having this issue is because you have a reference to a specific row - "[BRM Approved]1".
As you noted, you can copy/paste this, or even drag the formula down, but you cannot convert to a column formula with that syntax. However, is you drag the formula down from the top, you will most likely find that new rows will also start with the formula without needed a copy/paste.
Hope this helps,
Dave
Answers
-
Hi @Davey G,
The reason you are having this issue is because you have a reference to a specific row - "[BRM Approved]1".
As you noted, you can copy/paste this, or even drag the formula down, but you cannot convert to a column formula with that syntax. However, is you drag the formula down from the top, you will most likely find that new rows will also start with the formula without needed a copy/paste.
Hope this helps,
Dave
-
Thank you so much. That corrected my issue.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!