KT_H ✭✭✭

Overview

Overview

Roles	Member
Badges	10

About Me

About Me

Not much happening here, yet.

Analytics

29

Posts

76

Visits

146

Points

Jul 26, 2022

Join Date

Dec 2, 2024

Last Active

Reactions

• Vote Up 3

  3
• Awesome 1

  1

• Activity
• Discussions8
• Comments21

• Re: How to identify the first date and last date from another smartsheet column?

  KT_H

  07/26/22
  You can use a simple Max and Min type function if you are just looking for Latest and Earliest dates! Example: = MAX([Column End Date]:[Column End Date]) will pull the latest end date.
  1 ·

• Re: Where am I going wrong in this SUMIF formula?

  KT_H

  07/26/22
  Hi Kelly, You have the sum range and the criterion range flipped, try this. =SUMIF({Shell Projects - High Level Tracker Owner}, Wholesaler@row, {Shell Projects - High Level Tracker CP} )
  1 ·

• Re: Date difference calculation

  KT_H

  07/26/22
  I think the issue here is that your formula is written in reverse. Try this: =IF(ISBLANK([Closed Date]@row), NETDAYS(TODAY()-[Opened Date]@row), [Closed Date]@row-[Opened Date]@row)
  1 ·