"Active Last Month" Calculation?


I have created a Calculation Sheet (feeding in to a Dashboard) with Columns including "Started Last Month?" and "Ended Last Month?". Row data therein is either "Yes", "No" (or "#INVALID DATA TYPE" - not worried about this at moment).

I then have a further column, "Active Last Month?", which I want to report "Yes", "No" (or "#INVALID DATA TYPE" - not worried about this at moment).

The latest (but simplest) equation to fail I have tried is:

=IF([Started Last Month?]@row)="Yes",OR(IF([Ended Last Month?]@row="Yes"),"Yes","No"))

Comes back as "#UNPARESABLE".

Can anyone give advice?!?

Many thanks

Best Answer

  • Kelly P.
    Kelly P. ✭✭✭✭✭✭
    Answer ✓

    @Dan Edwards

    It sounds like this is what you are looking for, but if not then please provide more detail.

    =IF(OR([Started Last Month?]@row = "Yes", [Ended Last Month?]@row = "Yes"), "Yes", "No")

    Hope this helps!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!