Convert to Column Formula Error
I'm trying to make the below formula a column formula. If I copy and paste the formula into cells, it works as expected.
=IF(OR([Status]1 = "Complete", [Status]1 = ""), "", "Yes")
Two issues, though:
1) The [Status]1 brackets are being automatically removed and reformatted as Status1
2) When I try to convert to a column formula, I get the error "The column formula syntax isn't quite right."
What am I doing incorrectly?
Best Answer
-
You only need the brackets when the column name contains a space, number, and/or special character. Your column name doesn't contain any of those things which means the brackets aren't needed which is why Smartsheet is removing them.
The reason it cannot be converted into a column formula is because you are using specific row numbers. Column formulas must use "@row" references.
You have
Status1
You need
Status@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You only need the brackets when the column name contains a space, number, and/or special character. Your column name doesn't contain any of those things which means the brackets aren't needed which is why Smartsheet is removing them.
The reason it cannot be converted into a column formula is because you are using specific row numbers. Column formulas must use "@row" references.
You have
Status1
You need
Status@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!