ContributionsMost RecentMost LikesSolutionsRe: I am tracking aging of support tickets from two different systems.IF( isnull([date 3]) and isnull([date 4),today()-[date 1], isnull([date 3]), [date 2]-[date 1], not(isnull([date 3])) and isnull([date 4]),today()-[date 1], not(isnull([date 3])) and not(isnull([date 4])),[date 4]-[date 1], null)Re: I am tracking aging of support tickets from two different systems.if(isnull([date 3]), [date 2]-[date 1], if(not(isnull([date 3])) and isnull([date 4]),today()-[date 1], if(not(isnull([date 3])) and not(isnull([date 4])),[date 4]-[date 1], null)))Re: Is there a way to automate email notifications to users that will take them to their dashboard?In the email notification, you can pass a variable that will create a link to the app. If you put this: %appLink% in your custom email notification, it will send a link to the app. If they click on that link, it will show them their dashboard.Re: Status icon formula helpDon't use quotes - quotes are for textRe: Status icon formula helpTry .25, .50, .75Re: Status icon formula helpThis is a very complicated problem to solve that needs a bunch of setup work to get you to the point where you can create your formula. I can show you a demo of how we've set this up for other clients (we are a Quick Base development company) if you like. Visit my profile page or www.cirrusops.com Basically the problem is this: Tasks are not aware of any other tasks. Even with predecessors, they only become aware of the task that falls before it; though not any real information about the task, just the record id# of it, which is not helpful in your formula. Now, using summary fields in the relationship between projects and tasks, you can summarize info about specific tasks up to the project and then back down to all tasks with lookup fields. If you have a set list of tasks everytime, this can be done fairly easily. You can summarize whether a certain task is complete or not, even when it was completed. The other tasks related to that project can utilize that information to determine where it specifically fits into the project plan and if it is next or not. If you do not have set tasks lists, this method falls apart. In that case, we use some coding to solve the problem. Hope that is helpful - reach out to continue the conversation.Re: text OR date in same fieldThis example assumes you have a checkbox that tells you that milestone 1 is complete and a date field for milestone 1: if([milestone 1 complete]=true,"COMPLETE",totext([milestone 1 due date]))Re: Formula Field Coloring Helpyou're welcome! any time.Re: Formula Field Coloring Helpthe formula would look like this though: "<div style=\"font-size: 9pt; color:black;background-color:orange; width:80px; text-align:center; \">"&[YOUR FORMULA FIELD HERE]&"</div>",Re: Formula Field Coloring Helpyea, thats what I am thinking. It might be the fastest way to your solution.