Sum(IF(ISDATE

Robert S Fike
✭✭✭✭
Can this statement work. Getting a syntax issue.
=IF(ISDATE([Plans To Field Date]@row]@row), Sum(IF(ISdate([Slab Inspection]@row), 1, 0), IF(ISDATE([Frame Inspection Date]@row), 1, 0), IF(ISDATE([Cabinet Install Date]@row), 1, 0), IF(ISDATE([Final C.O. Date]@row, 1, 0) + 7)), SUM(IF(ISDATE([Spec Release Date]@row), 1, 0), IF(ISDATE([Selections Completed Date]@row), 1, 0), IF(ISDATE([Final Plans & Specs Done Date]@row), 1, 0), IF(ISDATE([Budgets & PO's Done Date]@row), 1, 0) + 2)
Best Answer
-
=IF(
ISDATE([Plans To Field Date]@row),
SUM(
IF(ISDATE([Slab Inspection]@row), 1, 0),
IF(ISDATE([Frame Inspection Date]@row), 1, 0),
IF(ISDATE([Cabinet Install Date]@row), 1, 0),
IF(ISDATE([Final C.O. Date]@row), 1, 0)
) + 7,
SUM(
IF(ISDATE([Spec Release Date]@row), 1, 0),
IF(ISDATE([Selections Completed Date]@row), 1, 0),
IF(ISDATE([Final Plans & Specs Done Date]@row), 1, 0),
IF(ISDATE([Budgets & PO's Done Date]@row), 1, 0)) + 2
Answers
-
=IF(
ISDATE([Plans To Field Date]@row),
SUM(
IF(ISDATE([Slab Inspection]@row), 1, 0),
IF(ISDATE([Frame Inspection Date]@row), 1, 0),
IF(ISDATE([Cabinet Install Date]@row), 1, 0),
IF(ISDATE([Final C.O. Date]@row), 1, 0)
) + 7,
SUM(
IF(ISDATE([Spec Release Date]@row), 1, 0),
IF(ISDATE([Selections Completed Date]@row), 1, 0),
IF(ISDATE([Final Plans & Specs Done Date]@row), 1, 0),
IF(ISDATE([Budgets & PO's Done Date]@row), 1, 0)) + 2
-
TYVM
-
Happy to help!😁
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 75 Community Job Board
- 502 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!