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,047

Visits

1.8k

Points

Nov 21, 2019

Join Date

4:27 pm

Last Active

Reactions

• Insightful 5

  5
• Vote Up 13

  13
• Awesome 12

  12

• Activity
• Discussions5
• Comments157

• Re: Data Point on Dashboard that updates based on current month

  Razetto

  07/26/23
  @Randy Van Winkle Try this instead: =COUNTIFS([Month #]:[Month #], @cell = MONTH(TODAY()), Status:Status, "Completed") Hope it works out.
  1 ·

• Re: "Invalid Data Type" Error - Need Formula Help!

  Razetto

  06/08/23
  @Ashley Pierce Try using the iferror: =IFERROR(DATE(YEAR([Column2]@row) + 3, MONTH([Column2]@row), DAY([Column2]@row)), "")
  1 ·

• Re: USing IF and ISBLANK with two columns

  Razetto

  06/06/23
  What about something like this? =IF(NOT(ISBLANK([Closure Date]@row)), " ", IF([Committed Closure Date]@row - TODAY() > 10, "Green", IF(AND([Committed Closure Date]@row - TODAY(…
  1 ·

Previous