Text mode for report to show people within certain teams/roles who have nothing assigned to them in a given time frame (today-end of the week 2 weeks out) | Community
Skip to main content
TimothyBr
TimothyBr
Level 4
January 21, 2026
Solved

Text mode for report to show people within certain teams/roles who have nothing assigned to them in a given time frame (today-end of the week 2 weeks out)

  • January 21, 2026
  • 2 replies
  • 26 views

Overall, I am just trying to get a list of people who dont have any active assignments. I think I got most of the way there but I feel like this is not bringing in items that people may be actively on but have a planned completion date farther out. 

 

What i have (user report)

 

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=ASSGN
EXISTS:a:assignedToID=FIELD:ID
EXISTS:a:task:plannedCompletionDate=$$TODAYbw
EXISTS:a:task:plannedCompletionDate_Mod=between
EXISTS:a:task:plannedCompletionDate_Range=$$TODAYb+2w
homeTeamID=682b957b0002e635c205140964bf4fe4    68263e760000b1d7ca24a3b6e5228b03    6532d3ca000df9c53a86ceac009cf030    66b0980f000d86a57d2968aa65dcdf38    63c8b4cd002c26378fd16b9e38d7e5e0    65fdbf8500153d4d1c01a9b6f877732f    6827a2c900045062834c7e844541a87f    682b943c00026e7376917ef3d94dff6c    682b94da0002a34ebc82c11ad099bdbe    68263ed50000d2da0cceaeaefe50d760    682b93e200024c738c45e2d4124a6dd1    682b439e0003f84d4ac7d6ebbbddc1b8    66d75f6000208bd5d2fcb2f570bdfadb    68263c2800003c301dd503c8c0fc5ab3    66db64a4005bb0023c9a6e32665ba34d    6827a1b50004051efeebfcbe898b5f9e    66269f5e0040ae3a601236ed691ac78f
homeTeamID_Mod=in
isActive=true
isActive_Mod=eq
roles:ID=621cfb4500021db396ad69cc7afce73e    6826328700066e56aeab67d19c97948d    68263290000672bb64e4d2c3c81ca17d    6826329c00067735cc9bd5506f3b8d21    682632a600067c7825442189e7e838b5    682632b4000681306d0d123208d160b9    682632e5000698135a087d620e6f0d11    682633d500014cff51e3b626365ed2bf    6453d34a001843233d0f5e73af423a75    657b526e001370d8daf28b4fbf890ec4    682633590006ca285e7cf7cdb2f89d57    682633650006cebd79ad98717d31e3f3    6826336f0006d42f19fa9ee35ae52b66    6826337c0006db8479e5bcdca0286bcd    682633870006deccad8b0b6fd40e99fc    682633980006e7ffb93752e9f0e79028    682633b8000147c3b198d80c59e1fa86    62ccd5340044c5b8437be6d15aba89c3    6218af7a00083536cdafc271bd9da6f2    645178ad001181e94f99ec36c91e6d11    62fb978a00404edf344c1bf96c0c67e3
roles:ID_Mod=in

    Best answer by IvanBebek-iX

    Hi ​@TimothyBr,

     

    I have not done anything similar to this but if I had to I would utilize an option to use OR condition OR:1: 

    For example:

    assignedToID_Mod=notblank
    OR:1:assignedToID_Mod=isblank

    In details in OR part I would have the exact same condition for the most of it but instead of plannedCompletionDate range I would have condition where task is not fully completed something like

    OR:1:task:percentComplete=100
    OR:1:task:percentComplete_Mod=ne

    Hopefully this makes sense, and hopefully it works, please let me know how it turns out. Thank you in advance.

    Best regards,
    Ivan 

    2 replies

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    February 2, 2026

    ​@IvanBebek-iX ​@Madalyn_Destafney ​@Sven-iX ​@Kurt_Jones Looping you in to see if you might have any insights or best practices to share on this topic. Your expertise would be really valuable, thank you!



     

    Kautuk Sahni
    IvanBebek-iX
    IvanBebek-iXAccepted solution
    Level 5
    February 2, 2026

    Hi ​@TimothyBr,

     

    I have not done anything similar to this but if I had to I would utilize an option to use OR condition OR:1: 

    For example:

    assignedToID_Mod=notblank
    OR:1:assignedToID_Mod=isblank

    In details in OR part I would have the exact same condition for the most of it but instead of plannedCompletionDate range I would have condition where task is not fully completed something like

    OR:1:task:percentComplete=100
    OR:1:task:percentComplete_Mod=ne

    Hopefully this makes sense, and hopefully it works, please let me know how it turns out. Thank you in advance.

    Best regards,
    Ivan 

      Terms & ConditionsAccessibility statement

      Loading footer...