I don’t think your current formula does what you want even when there is a date.
Try something like this. (I’m typing on a phone so there might be some typos. You might also want to throw in a check to see if the date is in the future. )
IF(
{Date Reservation Time Stamp},
CONCATENATE(
WORKDAY_DIFF(TODAY(),{Date Reservation Time Stamp}),
" Days Remaining"
)
)
I don’t think your current formula does what you want even when there is a date.
Try something like this. (I’m typing on a phone so there might be some typos. You might also want to throw in a check to see if the date is in the future. )
IF(
{Date Reservation Time Stamp},
CONCATENATE(
WORKDAY_DIFF(TODAY(),{Date Reservation Time Stamp}),
" Days Remaining"
)
)
thank you, This formula makes the count down change from 5 days remaining to 1 day remaining. I want it to count down from {Date Reservation Time Stamp}) each day that passes the counter would drop a day until it reaches 0
thank you, This formula makes the count down change from 5 days remaining to 1 day remaining. I want it to count down from {Date Reservation Time Stamp}) each day that passes the counter would drop a day until it reaches 0
@lucyk wrote:
thank you, This formula makes the count down change from 5 days remaining to 1 day remaining. I want it to count down from {Date Reservation Time Stamp}) each day that passes the counter would drop a day until it reaches 0
I'm having a hard time picturing this. Care to share a screen shot with example values?