Mario Valdes II

Follow
  • Total activity 22
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 6
  • Subscriptions 4

Posts

Votes on activity by Mario Valdes II Recent activity Votes

  • Help Diagnosing a Nested IF() Formula

    Answered
    1. Community
    2. Workbooks & Analytics

    If someone could help me diagnosis why the nested IF() formula below isn’t returning the expected result, I’d be grateful. I’ve got a date field (LATEST_PICKUP_DATE) wherein ‘null’ dates default to...

    • Mario Valdes II
    • Edited
    • 2 followers
    • 6 comments
    • 1 vote

  • Adding "H:mm:ss" values in one field to a DATE field

    Answered
    1. Community
    2. Questions & Answers

    I’m sorry if the title is a little hard to follow; I’ll do my best to explain better: I’ve got two fields, a DATE field in the DATE format, i.e.: “Dec 27, 2019 12:00:00 AM”, and a TIME field in a S...

    • Mario Valdes II
    • 2 followers
    • 3 comments
    • 1 vote

  • DATEDIF in Days, Hours, and Minutes

    Answered
    1. Community
    2. Tips & Tricks

    Good afternoon, all, Is it possible to calculate the duration between two dates and have the results return in a "Days, Hours and Minutes" format? E.g.: the result of the difference between "10/21/...

    • Mario Valdes II
    • 3 followers
    • 5 comments
    • 1 vote

  • Finding an average weekly count by year

    1. Community
    2. Workbooks & Analytics

    Hello, everyone, I've got a workbook which contains the following data points: A list of roughly 8 shippers A list of roughly 800 destinations facilities A count of distinct pallet IDs shipped fro...

    • Mario Valdes II
    • 2 followers
    • 2 comments
    • 0 votes