Razetto ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	25

About Me

About Me

Area of Expertise
About Me
How I Use Smartsheet
Linkedin
Twitter Page

Analytics

162

Posts

1,043

Visits

1.8k

Points

Nov 21, 2019

Join Date

Feb 27, 2025

Last Active

Reactions

• Insightful 5

  5
• Vote Up 13

  13
• Awesome 12

  12

• Activity
• Discussions5
• Comments157

• Re: COUNT(COLLECT) Status and Dates

  Razetto

  01/25/24
  @NickBlocker Hi, I would use a countifs instead of a count and collect. Try something like this: =COUNTIFS([Finish Date]:[Finish Date], AND(@cell >= DATE(2024, 1, 1), @cell <= DATE(2024, 12, 31…
  1 ·

• Re: Multiple IF Statement giving an #UNPARSEABLE error.

  Razetto

  01/04/24
  @Matthew R I changed it to read as blank and moved the parenthesis; see if this one works =IF(ISBLANK([QTY 1]@row), "0", IF([QTY 1]@row = "1", "1246", IF([QTY 1]@row = &…
  1 ·

• Re: COUNTIFS Error

  Razetto

  10/19/23
  @Julie Nelson Hi, Try using the @cell in your formula. =COUNTIF(Status:Status, @cell = "SI- Un...", [workover...]:[workover...], @cell= "Routine")
  1 ·

• Re: IF/And Formula to Change Symbols

  Razetto

  10/13/23
  @TolerDo Hi, try something like this instead =IF(NOT(ISBLANK([Column4]@row)), IF(AND([Column4]@row >= 80, [Column4]@row < 100), "Yellow", IF([Column4]@row = 100, "Green", &q…
  1 ·

• Re: Modification - URGENT

  Razetto

  10/04/23
  @JenaW You can set the sheet to trigger an update request after an approval, they'll be able to attached their pdf. Include the attachment field with the message
  1 ·

Previous Next