Generate a Report by using sheet summary

Nikki. A · 04/27/22

Thank you,

when I use the formula, it actually does not show anything for me :( I had to create a helper column that captures the item being completed in the last two weeks or not..

It just simply returns nothing otherwise , no error, nothing, just blank

=JOIN(COLLECT([Task Name]:[Task Name], Status:Status, "Complete", End:End, @cell > TODAY(-14), End:End, @cell <= TODAY()), CHAR(10))

Here is a screenshot

and the results

Nikki. A · 04/27/22

Oh Boy!

I just realized what was wrong : / I should've used Completed instead of Complete

Genevieve P. · 04/28/22

https://community.smartsheet.com/discussion/comment/327656#Comment_327656

Yes! Thank you for posting screen captures, that's exactly what I was going to say.

Does it work now that you're looking for "Completed"?

Nikki. A · 04/28/22

Yes it does :)

Generate a Report by using sheet summary

Answers

Help Article Resources

Categories