I'm trying to automatically populate emails depending on team member names.So if "John Smith" then in this column "john.smith@email.com" ""And if "Kate Jones" then "kate.jones@email.com" ""etcetcetcfor about 30 team members. I can get the first formu...
Hi everyone, I need to have a “Filter” column that is pulling date values from 3-4 different columns and selecting the one that is the most recent. So if we have 3/10/2021, 3/10/2022 and 3/10/2023, the date that populates the “Filter” column is 3/10/...
Hey everyone!
How do I create the statement to leave cell blank if a value is missing instead of #ERROR? I’ve read you should not use the BLANK() code?
Code for Days Left:
WORKDAY_DIFF(TODAY(),Starts)
Code for Urgency:
IF(
{Days Left} < 0,
"OVE...
Ah- ok @ScottWorld the Field Type must be set to Numbers in order for the MAX() to work. So it looks like Dates or even Single Line Text types don’t work. (unless you know a way to make it so it does that isn’t just MAX({Numbers 1},{Numbers 2})
Thanks scott – do you have further guidance on the formula itself?
I tried this and it just gave me 0
MAX({Job Information: Date}, {End Date (est)}, {Termination Date})
