Automation based on hyperlinks being added

arose
βββ
Hi,
We have a smartsheet where once an person's training is completed and reviewed a hyperlink is added to a specific cell associated to that person. Is there a way to make a different cell auto-populate a check box once a hyperlink has been added?
Answers
-
@arose if your hyperlink column is blank by default, I would use this formula on your checkbox column,
=IF(ISBLANK(HyperlinkColumn@row),0,1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!