error Unparseable in formual

Stephen Hindes

i have this formula and want to add one more critiria at the beginning. this one works good.

IF([Fint Cross]@row = "NA", IF([FTST Dock Date]@row - 8 < TODAY(), "Release Job", ""), IF([Fint Cross]@row - 8 < TODAY(), IF([Main Frame %]@row > 0.5, IF([CH % comp]@row > 0.5, "Release Job", ""), ""), ""))

Tried this by itself and it works, good.

=IF([FTST release date]@row > DATE(2020, 1, 1), "T", "F")

when i combine them, i get the Unparseable. it the statement is false, i was put "heelppp" in the cell, will change after i get it to work.

=IF([FTST release date]@row > DATE(2020, 1, 1), ([Fint Cross]@row = "NA", IF([FTST Dock Date]@row - 8 < TODAY(), "Release Job", ""), IF([Fint Cross]@row - 8 < TODAY(), IF([Main Frame %]@row > 0.5, IF([CH % comp]@row > 0.5, "Release Job", ""), ""), "")), "heelppp")

can anyone help in in desiding what i am doing wrong.

Christina09

try this:

=IF([FTST release date]@row > DATE(2020, 1, 1), IF([Fint Cross]@row = "NA", IF(sent@row - 8 < TODAY(), "Release Job", IF([FTST Dock Date]@row - 8 < TODAY(), IF([Main Frame %]@row > 0.5, IF([CH % comp]@row > 0.5, "Release Job"))))), "heelppp")

Stephen Hindes

=IF([FTST release date]@row < DATE(2020, 1, 1), IF([Fint Cross]@row = "NA", IF([FTST Dock Date]@row - 8 < TODAY(), "Release Job", IF([Fint Cross]@row - 8 < TODAY(), IF([Main Frame %]@row > 0.5, IF([CH % comp]@row > 0.5, "Release Job"))))), "done")

the got rid of the error but the logic did not work

FTST Release date=bland Fint cross="NA" FTST dock date=10/2/21

result is = no comment, the result should be "release job"

diff scenario did not work also

FTST Release date=bland Fint cross=10/2/21 FTST dock date=10/5/21

result is = no comment, the result should be "release job"

Christina09

@Stephen Hindes

I'm not sure what you mean, but if you screenshot it, it might helps us having a better understanding

Stephen Hindes

will this help

Stephen Hindes

logic might help

FTST release date exsist, Ftst release = "done"

if fint cross =NA, yes- FTSTdock date-8 < today =release, FTST no - BLANK

no - Fint cross date -8 < today =release and Mainfram%>.5 and CH%>.5 =release job

if it does not fit all these the leave blank - ""

let me know if this helps

Stephen Hindes

got it to work.

=IF([FTST release date]@row < DATE(2020, 1, 1), IF([Fint Cross]@row = "NA", IF([FTST Dock Date]@row - 8 < TODAY(), "Release Job", ""), IF([Fint Cross]@row - 8 < TODAY(), IF([Main Frame %]@row > 0.5, IF([CH % comp]@row > 0.5, "Release Job", ""), ""), "")), "√")

Christina09

@Stephen Hindes

glad it works now :)