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!
Help Article Resources
Categories
Check out the Formula Handbook template!
