bbates ✭✭✭

Overview

Overview

Roles	Member
Badges	4

About Me

About Me

How I Use Smartsheet	Project Management

Analytics

10

Posts

19

Visits

245

Points

Oct 12, 2023

Join Date

Dec 15, 2023

Last Active

Reactions

• Vote Up 1

  1
• Awesome 2

  2

• Activity
• Discussions1
• Comments9

• Re: Formula that compares three Columns on the same Row

  bbates

  10/13/23
  Here you go: =IF(AND([Utility CR]@row <> "", [Telecom CR]@row = "", [Waste CR]@row = ""), "Utility Only", IF(AND([Utility CR]@row = "", [Teleco…
  1 ·

• Re: Formulas

  bbates

  10/13/23
  Percentage values are 0-1 which is the issue here, try this: =IF([% Complete] = 0, "Not Started", IF([% Complete] = 1, "Complete", "In Progress"))
  1 ·