Jeffrey_WRK✭

About

Username
Jeffrey_WRK
Joined
Visits
22
Last Active
Roles
No Roles
Points
8
Badges
2
How I Use Smartsheet
Portfolio and Program Management

Comments

  • 看看这匹配你的目标。做I understand correctly that Tasks 3 and 6 should be false, or at least never likely to be an option to consider? MATCH Start: =MATCH([Project Start]@row, Start:Start, 1) MATCH End: =MATCH([Project End]@row, Start:Start, 1) Check Start: =IF(AND(INDEX(Start:Start, [MATCH Start]@row) <=…
    inCan I determine if dates fall within a range of other dates? Comment byJeffrey_WRK 04/11/22
  • I'm not sure I understand the problem, but here's a possible solution. I put both sheets in one for simplicity. Left of the black column is the Project sheet, the Moratorium and Holidays sheet is on the left. I use MATCH (search type 1) in a helper column to find the relevant moratorium row. Then in the Moratorium column…
    inCan I determine if dates fall within a range of other dates? Comment byJeffrey_WRK 04/07/22
  • Use INDEX-MATCH with the MATCH search type of "1": =INDEX(Location:Location, MATCH([Total Equiv. Miles]@row, Cumulative:Cumulative, 1)) I put both sheets in one for simplicity. To the left of the black bar is Sheet 1 and Sheet 2 is on the right.
    inHow to select result from table of data? Comment byJeffrey_WRK 04/07/22
  • Your Excel formula only gives years, not years and months. Here's a few options. If Date1 is their birthday and Date2 is their request date, then you can get years by this: =ROUNDDOWN(NETDAYS([Date1]@row, [Date2]@row) / 365, 0) RESULT: 62 ------------------------------- If you want decimal years, use it without the…
    inFORMULA FROM DATE TO DATE Comment byJeffrey_WRK 04/07/22
Avatar