Formula to calculate the number of minutes request for a specific date and review board

Options


I have a sheet that is an agenda submission for teams, and then another with a list of dates that calculates how much time is left for a specific date and review board (Primary Column). I have three review boards on the same date, so I want this sheet to pull only the Meeting Duration (Duration) for topics going to one specific review board. I did the below and am getting the #INCORRECT ARGUMENT SET.

Any suggestions?


=SUMIFS({Review Board}, [Primary Column]@row, {Date 2}, [Start Date]@row, {{Duration})

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Leann Gibson

    With a SUMIFS plural, the structure is actually opposite to a SUMIF singular. In SUMIFS, you'll want to list the Range to SUM at the very beginning of the formula instead of at the end.

    Try something like this:

    =SUMIFS({Duration}, {Review Board}, [Primary Column]@row, {Date 2}, [Start Date]@row)

    I also took out an extra { that you had around Duration. Let me know if this works for you!

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!