Report filter Actual End Date is less than or equal to Planned End Date
Hi,
I am creating a report to extract info for tasks that are overdue or completed ahead of time but as I filter the report for Actual End Date condition I am not able to link the Planned End date (Actual End Date <= Planned End Date) but I am force to enter a date since Actual date is a date column.
Do you have a workaround for this?
Thanks in Advance!
Best Answer
-
You are going to need to add a column in the source sheet that does the comparison and flags each row you want to pull and then base your report off of that column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You are going to need to add a column in the source sheet that does the comparison and flags each row you want to pull and then base your report off of that column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives