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
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 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!