ContributionsMost RecentMost LikesSolutionsRe: Formula Date > Text field Thank you! this worked ------------------------------ Korrie Clark ------------------------------ Re: Formula Date > Text field I am getting an error on the 1 week line var date MyDate = [Estimated Review Start Date]; var date SundayOfDateWeek = FirstDayOfWeek($MyDate); var Date SundayOfToday = FirstDayOfWeek (Today()); If( $MyDate < Today(), "Past", $SundayOfDateWeek = $SundayOfToday, "This Week", $SundayOfDateWeek = $SundayOfToday, + Weeks(1), "Next Week", $SundayOfDateWeek = $SundayOfToday, + Weeks(2), "2 Weeks Out", $SundayOfDateWeek = $SundayOfToday, + Weeks(3), "3 Weeks Out", $SundayOfDateWeek > $SundayOfToday, + Weeks(4), "Next Month") ------------------------------ Korrie Clark ------------------------------ Re: Formula Date > Text field regardless of actual calendar months i want next week to be the primary answer if it is in fact next week, but if its not in any of the other categories like 1-2 weeks next month basically just 4 weeks out would be next month, and anything beyond that would be too far into the future ------------------------------ Korrie Clark ------------------------------ Formula Date > Text field Looking for a formula that can take a date field and tell me "Next Week", " In Two Weeks", "Next Month", "Future" (aka too far beyond next month) ------------------------------ Korrie Clark ------------------------------ Re: Numeric equivalent of "List" formula That worked, thanks! __________________ Korrie Clark | Manager- Business Processes TransPerfect Staffing Solutions 1717 Main St Dallas, TX 75201 t. 214-744-4200 | m. 917-882-6894 www.transperfectlegal.com Visibility. Predictability. Clarity. Numeric equivalent of "List" formulaI figured this would be easy but i can't get it to work, basically I'm looking to list numeric values possibly with a tag. Basically I have two fields, lets call them Boys and Girls both numeric values I want to show them in one field in a calendar view as: "Boys: 5, Girls: 2" I figured you could do some kind of List("," "Boys:"[Number of Boys], "Girls:" [Number of Girls]) but since they're numeric it doesnt work- is there anything similar to this that will do what i want? ------------------------------ Korrie Clark ------------------------------ Re: Bi Monthly Billing Calculated Field based off Date chosenWhat is the value you're calculating the timeframe on? Is it all records due on the 15th or the 31st or is it based on some form of date criteria already- i.e. contract start date, user input deadline? It seems like when building a table you should be able to set criteria similar to the below based on what you're reference field is (i'm using deadline as an example): Deadline = during= current= month Deadline=during= past= 15 = days To have on the homepage dashboard, it won't show a table that requires a "user select" date, you'd need to create a shortcut button to the full table if you want to sort based on something that the user selects uniquely each time. You could however show the above formula and also add a criteria of something like "sales person= the current user" and it would show only records for that user with the additional criteria. Hope I understood what you meant! ------------------------------ Korrie Clark ------------------------------ Re: QB sending alert to the sender of a notification - can it be turned off?Yes, this should be pretty easy for the app admin to do in the "notifications/subscriptions" settings You can usually specify if you want to send the email to yourself, to others, to specific others, to people in X field etc. ------------------------------ Korrie Clark ------------------------------ Transpose Data to another field?Re: I need to use a field from one tab in a table report on another tabWould it help to do a screen share? I can send you an invitation for that if needed.