Apply Date parameter in different rows

Hello,

I need to use the same date in different rows but using a formule.

I built a sheet named "Meses" with the dates like below:

to use the same dates in different rows instead of changing by hand. However it is not working because it is returning 0 in the formule below (for example):

=SUMIFS({Project_Product Release Roadmap Intervalo 11}; {Project_Product Release Roadmap Intervalo 2}; Resource318; {Project_Product Release Roadmap Intervalo 3}; {Meses Intervalo 3}; {Project_Product Release Roadmap Intervalo 3}; {Meses Intervalo 4})


If I use the dates inside works perfectly:

=SUMIFS({Project_Product Release Roadmap Intervalo 11}; {Project_Product Release Roadmap Intervalo 2}; Recurso318; {Project_Product Release Roadmap Intervalo 3}; >=DATE(2020; 10; 1); {Project_Product Release Roadmap Intervalo 3}; <=DATE(2020; 10; 2))

Could you help me?

thank you

Best Answers

Answers

  • M Underbrink
    M Underbrink ✭✭✭✭✭

    If you pull the range into a DATE() formula in your equation, would that work?

    DATE({Meses Intervalo 3})

  • Hello,

    Thank you for the answer.

    Did not work. Appears the error below:



  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Angela Formiga

    You will need to reference a specific criteria after each {range}, instead of referencing an entire column after a range... this is why you're getting an error with your first formula but not with your second.

    How is this formula being used in your destination sheet? Could you have specific dates listed in a Date Column in this sheet, and use that as your reference?

    EX:

    =SUMIFS({Project_Product Release Roadmap Intervalo 11}; {Project_Product Release Roadmap Intervalo 2}; Recurso318; {Project_Product Release Roadmap Intervalo 3}; >=[Date Column]$1; {Project_Product Release Roadmap Intervalo 3}; <=>=[Date Column]$2)

    ^Here I would have your two dates in rows one ($1) and two ($2). Would that work for you? If not, it would be helpful to see a full screen capture of both sheets (but please block out any sensitive data), with an explanation as to what each of your cross-sheet references are referring to.

    Cheers,

    Genevieve

  • Hello @Genevieve P


    Thank you for the feedback. I tried what you say and did not work.

    Returned the error Incorrect Argument SET"

    My date columns are:


    Maybe it is the format?

  • Hello @Genevieve P,


    It is exactly that and worked perfectly :)


    Thank you very much for the help. It was a big help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!