The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi!Two formula questions - I have (4) different date fields with timestamps and need to identify the latest date across the four fields. When doing a Max value, it does not bring in the timestamp or makes it 12:00a as a standard. I also have (2) date...
Hello!I have a formula field that calculates the number of hours between two date fields. I want to then parse this into categories based on the duration:A = hours ae greater than 96B = hours are greater than 24, but less than 96C = all remaining pos...
Hello!I have two fields that I want to meet certain criteria to return a value in another field.Return Value "Late" if field 1: Advanced Record contains "ADVANCED" and Field 2: If Date/Timestamp is after 10p EST otherwise return "On Time" if Date fie...
Hello!I am looking for a formula that will update on a month basis to pull data for a meeting.I have a few dates I want to pull from - Target Start, Target Completion Date, and Dev start. I would like to label any records that have a date in the upco...
Hi! I am so sorry, was on vacation... which may have helped because I realized it wasnt working since I had time off in the formatting Thank you SO much!!
Yes! I have these date ranges below - I would like it to if the start/on boarding is in the current month or past and to reflect as "NOW", those with a date for the processing or on-boarding within the next 3mo to reflect as "NEAR" ... after thinking...