IF AND formula to determine number of days
Hi team - I imported this Excel spreadsheet but the formulas aren't the same in Smartsheet so I need help.
So in the encircled cell the Excel formula reads: =IF(AND(T2<>"",U2=""),DAYS(AC2,T2),"")
- T column = DD Kick Off Date
- U column = Date DDQ sent to TP
- AC column = Today's Date
I need a Smartsheet formula that states: if T column is not blank and U column is blank then count the number of days between AC (today's date) and T column (DD Kick Off Date). See third data row for an example output.
Thanks, in advance, for any assistance!
Best Answers
-
Try the below,
(Btw, unless the Today's Date column is used for any other purposes, you can remove that column as you can use the TODAY() function in SS and Excel both. If you do remove that column then just replace [Today's Date]@row in the formula below with TODAY())
=IF(AND(NOT(ISBLANK([DD Kick Off Date]@row)), ISBLANK([Date DDQ sent to TP]@row)), [Today's Date]@row - [DD Kick Off Date]@row, "")
-
Glad it helped. Looks like you mentioned someone else in your reply :-)
Answers
-
Can you provide the names of each column title to the corresponding excel column?
- T column = DD Kick Off Date
- U column = ?
- AC column = ?
-
Yes - they are
- U column = Date DDQ sent to TP
- AC column = Today's Date
- T column = DD Kick Off Date
-
Try the below,
(Btw, unless the Today's Date column is used for any other purposes, you can remove that column as you can use the TODAY() function in SS and Excel both. If you do remove that column then just replace [Today's Date]@row in the formula below with TODAY())
=IF(AND(NOT(ISBLANK([DD Kick Off Date]@row)), ISBLANK([Date DDQ sent to TP]@row)), [Today's Date]@row - [DD Kick Off Date]@row, "")
-
That worked @Sameeh Akram.
I removed the [Today's Date]@row reference and just used TODAY() instead.
Thanks for your assistance.
-
Glad it helped. Looks like you mentioned someone else in your reply :-)
-
Doh - I sure did @Sameer Karkhanis. Was typing way too fast in my excitement to get this solved. :-)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!