Question:
I have this formula to pull the latest revision in the Submittal revisions for art work.
IF({SUBMITTAL: REVISIONS},SUBSTITUTE(
RIGHT(‘’&{SUBMITTAL: REVISIONS},1+
LEN(‘’&{SUBMITTAL: REVISIONS})-FIND(‘https:’,‘’&{SUBMITTAL: REVISIONS},LEN(‘’&{SUBMITTAL: REVISIONS})-133)
),‘)’,‘’
))
It’s an attachment field called Submittal Revisions. I have another attachment field called Previous Stage with an approved attachment file - always filled in with a file.
That said, sometimes the SUBMITTAL: REVISIONS attachment filed is empty and doesn’t have any data to pull from. Can we add in that if the SUBMITTAL: REVISIONS is empty, it pulls from the PREVIOUS STAGE file?
Thank you!
