Number of Month Payback ROI


Hi everyone,

I have created a form and the pictures below is what is relevant to my question. We have projects with a fiscal year start date and end date, we also want to know the payback date. I did not chose the "date" function on the column as we are only interested in the fiscal year, but maybe there is a work around.

What I am trying to do is automatically calculate the "Investment will be paid back by" column. What I have so far is a calculation that determines how many months and then it is added to the "Fiscal Year Start Date Column" as you can see it produces "6-2020/21", ideally I would like it to show June-2020/21. Something along those lines.


Best Answer


  • Lila De Vera
    Lila De Vera ✭✭✭✭✭

    Thanks @David Joyeuse this will work. Ironically bringing me back to the dreaded INDEX/MATCH.

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    @Lila De Vera

    You'll notice with experience that both INDEX/MATCH and COLLECT are powerful functions within Smartsheet.

    Glad it worked!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!