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 = ?
Travis C, PMP
Smartsheet Leader with 5+ years of SS experience
Let's connect: LinkedIn - Travis C.
If my answer was sufficient, pleaseupvote and mark my response as answered.
-
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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!