General Update on Assignments formula with Today - x
Hi all,
as you may be all aware, I'm definitely not the most versed in the formulas when it comes to Smartsheets. I'm a self-study without any prior experience and I did learn a lot and can address the majority of issues myself, being thankful to you all. Now, however, I am asking for help again. I'd like to build a formula that counts the # of assignments per resource based on duration. While this sounds easy, I need to emphasise that the same resource is on 5 different lines for the project and I would like to count in only the parent line. Is that something possible? (please note that the second screenshot is purely illustrative as per source sheet, and it's the top screen of how layout would be.) I'm totally open to helper rows, columns, anything. I'd like to monitor it daily within past two weeks so my formula would be like =TODAY()- 14 or something like that, I'm not sure.
Best Answer
-
Since you can't use "@cell" references in hierarchy based functions, you will need to insert a helper column to mark each of the parent rows and then incorporate this range/criteria set into your formula.
Answers
-
Since you can't use "@cell" references in hierarchy based functions, you will need to insert a helper column to mark each of the parent rows and then incorporate this range/criteria set into your formula.
-
Thanks Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!