I currently use the following formula to produce a unique identifier in my my primary field: "PHDEV-" & {Fx_Year} & "-" & REPT(0,3-LEN(CONCATENATE({Fx_Autonum}))) & Fx_Autonum This works as intended, but I'm at a loss understanding how I might expand...
I want to use an IF statement in a field where the logic will basically be the following:
IF({Calibration Frequency}= Annual, ({Last Calibrated}+365 days))
I know this isn’t a valid way to code this - strictly an attempt to explain the intent. But ba...
@Justin_Barrett @Mohamed_Swellam One last question: If i wanted to further DATETIME FORMAT the output to exclude the time and instead display just the month and year, how would i incorporate that code into this one you’ve provided?
Hi @Justin_Barrett. Thanks for the reply. The {Last Calibrated} field is formatted as a Date field and the {Calibration Frequency} is set up as a single select. No Lookup field is in use. @Mohamed_Swellam 's code is still not working for some reason....
Thanks @Mohamed_Swellam. I think I incompletely described the base structure though.
So, there are two existing columns that will be referenced, and one new column field which i’m intending to code to produce a “Calibration Due” date. The two existin...
