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
-
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"
-
I'm not sure what you mean, but if you screenshot it, it might helps us having a better understanding
-
will this help
-
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", ""), ""), "")), "√")
-
glad it works now :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!