Forum Discussion
Custom/Conditional Column IF Date = Today then YES
NB3 , Try new columns like
new col 1 =
Switch( true(),
[Date]=today() , "Yes", "No")new col 2 =
Switch( true(),
[Submitted Date].date = [Last Activity].Date , "Yes",
[Submitted Date].date >= [Last Activity].Date && [Submitted Date].date <= [Last Activity].Date + 1 + time(9,0,0),"Yes",
"No"
)NB3 , let us change it a bit
new col 2 =
Switch( true(),
[Submitted Date].date = [Last Activity].Date , "Yes",
[Submitted Date] >= [Last Activity].Date + time(17,0,0)&& [Submitted Date] <= [Last Activity].Date + 1 + time(9,0,0),"Yes",
"No"
)
Hi amitchandak ,
Your second formula works perfectly. I got one question though for the first one.
It's working but it shows "YES" only for the row whose Date/Time is today at 12:00:00 so I have 1 showing and should have 70.
Also, would you happen to have a formula that shows a "YES" column for applications submitted after 5pm yesterday and before 9am today?
Thanks a lot for your help !
Nick
NB3 , let us change it a bit
new col 2 =
Switch( true(),
[Submitted Date].date = [Last Activity].Date , "Yes",
[Submitted Date] >= [Last Activity].Date + time(17,0,0)&& [Submitted Date] <= [Last Activity].Date + 1 + time(9,0,0),"Yes",
"No"
)