Star Help - Checkbox column type with Stars - How to Automate?

There is no option create an automation to "change cell" with a column type that is the checkbox - Star icon feature. It is missing as an option when you go to create it. You can use regular check boxes - but if its a star its not an option. I tried to do a manual IF formula to star a cell if conditions are met and its not working.
Please help me automate this field! Leadership wants stars and not checkboxes if a dropdown column is a certain type.
Best Answers
-
You are correct that you will need a formula instead of an automation. An IF statement should work though.
=IF([Dropdown Column Name]@row = "Certain Type", 1)
-
There should only be one comma in the formula (the one before the 1). Try removing the comma after the cell reference.
Answers
-
You are correct that you will need a formula instead of an automation. An IF statement should work though.
=IF([Dropdown Column Name]@row = "Certain Type", 1)
-
Thanks for taking the time to answer this Paul - but the formula is not working. It keeps giving an #INVALID DATA TYPE response.
-
Are you able to provide some screenshots for context?
-
This is the formula - and if there is nothing in the Value Drop or Feature Column - it stars it (which is incorrect behavior). If there is data in that column (as there should be) - it give #INVALID error. I tried many versions of this formula and nothing is working.
-
There should only be one comma in the formula (the one before the 1). Try removing the comma after the cell reference.
-
Oh my goodness that worked! Thank you so much Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!