Generate a Report by using sheet summary
Options
Answers
-
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
-
Oh Boy!
I just realized what was wrong : / I should've used Completed instead of Complete
-
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"?
-
Yes it does :)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!