hi! I have a field that is manually entered and I’m trying to create a formula field that extracts the middle number (found between “-” and “.”) but excludes the starting zero’s. This middle number can range from 1 to 999. I’ve tried a variety of Ri...
It appears that the Charts are only showing the Primary field, X axis & Y axis field when you click on a section to drill down on the graph however it used to show the Primary field as well as the first few fields of the associated View.
So in this e...
I’m looking to create a datestamp field based on if a Single Select field is either COMPLETE or CANCELED, otherwise it should remain empty.
I’ve searched through this site and tried a variety of options but have had no success.
IF(OR(Status=“COMPLETE...
I’m currently using the following formula for tracking Project Health: IF({FOC (Current)}<TODAY(),“LATE!”,“ON TARGET”)
however there are times when the “FOC (Current)” date field is appropriately blank. Right now it’s labeling it as “Late” but I need...
Hi! I’ve been using the below formula for awhile, but it returns an #ERROR! for the fields where {FOC (Current)} is blank. For cleaner reporting I’d like to have it return as “PENDING” but can’t seem to get an IF formula to work successfully. Any sug...
Thanks that worked! I tried so many options that I had lost count of the variations. :slightly_smiling_face:
I can’t believe I missed this one as it makes so much sense.
