error Unparseable in formual

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.

Answers

  • Christina09
    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")

  • =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
    Christina09 ✭✭✭✭✭✭

    @Stephen Hindes

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

  • 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

  • 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
    Christina09 ✭✭✭✭✭✭

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!