Logic formula for checkbox

Stephanie Firth

Stephanie Firth ✭✭

04/21/20 in Formulas and Functions

I am trying to get a box checked if a completion date has been entered OR a status has been marked complete.

Formula I have is

=IF (Status3 = "Complete") OR NOT(ISBLANK([Real Completion Date]3)),1

What am I doing wrong here?

Tags:

0 ·

Best Answer

Stephanie Firth ✭✭

04/21/20 Answer ✓

I have figured it out now

0 · Share on Facebook Share on Twitter

Answers

Stephanie Firth ✭✭

04/21/20 Answer ✓

I have figured it out now

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

If Statement with Multiple Factors
Hello, Sorry for needing additional formula help. For the HTN Kit Helper, I need to it either display Blood Pressure Kit with the Educational Language Helper, except if BP cuff helper is Extra Large Cuff I need it to only display "Extra Large Cuff" in the HTN Kit Helper column =IF([CK Type Helper]@row = "Blood Pressure…
Formula for auto number/prefix based on groups
I have a sheet with several parent-child hierarchies where I have things grouped by Workstream. I want each task under each workstream to have a unique task ID with different pre-fixes depending on the workstream. Ex: Data tasks would be D1, D2, D3, etc. Organizational Change Management tasks would be OCM1, OCM2, OCM3,…
Hello, am trying to lock rows once a cell in one column has been checked
I created an automation to lock rows once the the specific column has been checked, but when i go back to the sheet, i can still be able to edit it. What am i missing, how can i fix this to have rows locked? Thanks