nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

こんにちは！

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

IF Function with Checkbox

jsurra

I'm trying to create a formula....If the checkbox is "checked" in the Toledo column, then display the formula result that's in the price/ft column. If the checkbox is not checked then price/ft column is blank.

Any help is appreciated.

Thx

Joe

smartsheet ex.PNG

Mike Wilday

The following formula should be used in row 12... or adjusted to correct row number. Basically, it's looking to see if the Toledo checkbox is checked (checked boxes contain = 1, unchecked boxes = 0), if it is, then it will run the formula, if it's not the field will be blank, indicated by an empty string of text. ""