Formula to pull the current auth level based on the most recent "date from" in each grouping?

Todd O
Todd O
edited 04/18/24 in Formulas and Functions

I would like to collect the current Auth level into another sheet using the Name as the identifier (what formula would look at the parent and child rows together to determine the current auth for each person?) Any help would be much appreciated. Thank you

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Todd O

    Can I verify how you're building the formula? Are you copy/pasting from here in the Community, or building it step-by-step?

    Invalid Reference usually indicates that one of the {cross sheet references} has not been set up correctly. Can you check to ensure you're looking at the correct columns for each of these:

    • {Authorization Level}
    • {Date From}
    • {Name}


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!