kirstie858 · Data Architect · ✭✭✭✭

Overview

Overview

Roles	Member
Badges	12

About Me

About Me

Title	Data Architect
Industry	Biotechnology
Area of Expertise	Data Modeling, ER Diagrams, Reporting, Metrics, Visualizations, Data Analyses, PowerBI, PowerQuery, Salesforce, Labmatrix
About Me	Data Architect - Data Modeling Wizard and Data Literacy Evangelist.
How I Use Smartsheet	Making lives better, one workflow at a time.

Analytics

20

Posts

73

Visits

385

Points

Aug 26, 2021

Join Date

Jan 16, 2024

Last Active

Reactions

• Vote Up 1

  1
• Awesome 2

  2

• Activity
• Discussions
• Comments20

• Re: Adding another parameter to IF(OR) with multiple conditions

  kirstie858

  04/26/23
  FYI - a checkbox evaluates to true or false. Also, I assume [Docs Check Date] was supposed to be [Docs Check Date Helper] in paragraph 2. I like to break down complicated formulas into parts. I take …
  1 ·

• Re: Why can't I convert this formula into a column formula?

  kirstie858

  09/29/22
  Hi! I believe it's your cell references. Instead of referencing a specific row 2, use @row. =IF([Start Date]@row > TODAY(), "Blue", IF(AND([% Complete]@row < 1, [End Date]@row < TO…
  1 ·