ContributionsMost RecentMost LikesSolutionsRe: active projects trend graphHi Kevin, can you specify what you mean exactly when you say "snapshot of active projects"? I understand the part regarding creating a table, and relationship, and maybe even lookup fields,... but could you clarify a bit more about what you mean?Re: active projects trend graphor some summary field where I would summarize project that started before some date, and have not ended by the same date.... but then I would have 6 separate summary fields.... maybe I can use that as a starterRe: active projects trend graphHi, aging is not the issue, I already have that one solved for the series, the problem is the X axis. That axes should present months, and the bars should show number of active projects in that specific month, Like in the chart bellow. I've resolved the part regarding project aging, the only problem I'm having is to set active projects in each month. active projects trend graphI'm trying to create a stacked graph that will show all active projects per months (eg. last 6 months), where I would include following: * all active projects 6 months ago, * then all active projects 5 months ago (exclude closed ones and include new ones) and so on, but those projects should be in the aging group (i've already created a field for that). I have project start date, and project close date fields, and I am trying to find the best solution for this. Thank you in advance.if criteria is met chose from two optionsI am trying to create a formula text field where on choices I would have either one result, or a possibility to chose from the two....the example is bellow: Field name is: MT (example) If ([FIELD 1] = "", "General", If ([FIELD 2] ="", "Fluid", and now the problematic criteria:If ([FIELD 3] =<>"", "Flexible" or "Optimized" In other words if Field 3 is not blank, I should have a choice to select either Flexible or Optimized. Is there a way to do that?Re: multiple selection & if values match, show me the list belongingYup, that does the trick :) one additional question, if its not a problem... Since Product Name is a drop down field, is there a way to define what to show in the picker, since now I'm having excessive information: Product # 3 - Product Group 1 - Product name (so practically this makes it difficult to choose)?Re: multiple selection & if values match, show me the list belongingWow, I really appreciate this answer/explanation, it doing-while reading, made it look so simple I felt embarrassed not knowing about it, especially field "conditional values". If you have time could you please clarify the part in the Grid view that you've explained? Just to add, now I've achieved the desired goal, and with save & add another I can have what I want to, but I have to ask if there is a way to make it even simplier? I mean adding services, without clicking save and add another? (any suggestion for this would be appreciated. The idea behind is to create a product/service bundle....multiple selection & if values match, show me the list belongingI have the following situation, where I would need assistance if possible, and there are two parts of this request. Part 1. _I have one table where I have Product names and versions (one product may have more versions). In the next table I am trying to create a situation where when I choose a product from the list, I'd be offered only with the selection of versions belonging to that Product. Example: _Product X has versions 1.0; 1.5; 2.0, and Product Y has versions 2.0; 2.2; 3.0 when I select Product X, or Product Y in the next field I would have the choice of selecting only versions belonging to the product. Part 2._ Part 2 is actually related to Part 1 in a matter that I would need to have a multiple choice, where I would have the opportunity to select 1, 2, 3 or 4 products and for each product to select the appropriate version. I would appreciate any help on this matterRe: Compare values with values from previous monthunfortunately that didn't work, I'll try to review all my steps from above with what I've done, and see where the problem is.Re: Compare values with values from previous monthdo I need to do the subscription part before or?