Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 19, 2023 04:46 AM
Hi All,
I've been trying to use the below formula to exclude weekends, so rather than showing 7 days to show 5 days instead. it seem to make sense using 3 but I'm not sure why? when the formula is returned and Date Reservation Time Stamp is blank it returns NaN Days Remaining is there a way to say IF {Date Reservation Time Stamp} is blank show as Blank on the output?
formula I'm currently using
Jul 19, 2023 05:20 AM
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"
)
)
Jul 19, 2023 06:03 AM
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
Jul 19, 2023 09:47 AM
@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?