+7I have a lot to learn in terms of building formulas, and I'm found myself stuck and not sure what I'm missing.
What I'm trying to accomplish:
My current (not working) formula:
Best answer by Josh_Colina
I think part of where this formula isn't working is in designating "TRUE" - you can actually accomplish this with the checkbox field just by using
IF({Completed}, "Completed")or, if there is something at all in the Completed checkbox field (i.e. it is checked), return "Completed." I would also use TONOW() rather than the DATETIME_DIFF. Here's what I used!
IF(
{completed},
"Completed",
TONOW(
{Ready for Pickup Timestamp}
)
)+10I think part of where this formula isn't working is in designating "TRUE" - you can actually accomplish this with the checkbox field just by using
IF({Completed}, "Completed")or, if there is something at all in the Completed checkbox field (i.e. it is checked), return "Completed." I would also use TONOW() rather than the DATETIME_DIFF. Here's what I used!
IF(
{completed},
"Completed",
TONOW(
{Ready for Pickup Timestamp}
)
)+7I think part of where this formula isn't working is in designating "TRUE" - you can actually accomplish this with the checkbox field just by using
IF({Completed}, "Completed")or, if there is something at all in the Completed checkbox field (i.e. it is checked), return "Completed." I would also use TONOW() rather than the DATETIME_DIFF. Here's what I used!
IF(
{completed},
"Completed",
TONOW(
{Ready for Pickup Timestamp}
)
)Thank you so much, Josh! I like the TONOW idea, but I ended up going with the DATETIME_DIFF because it let me specify showing the units in days which should make my email send automation a bit easier.
Thank you so so much for the quick reply!
+7@Josh_Colina , oh uh, I spoke too soon! The formula I thought was working is actually displaying blank cell instead of a number of days (see screenshot). The "completed" part of the formula is working. Any tips for this?
Thank you!
+10@Josh_Colina , oh uh, I spoke too soon! The formula I thought was working is actually displaying blank cell instead of a number of days (see screenshot). The "completed" part of the formula is working. Any tips for this?
Thank you!
Hi Spruce! Here's what I tried that seems to be working for me - unsure why exactly but NOW() seems to work better than TODAY()
IF(
{Completed},
"Completed",
DATETIME_DIFF(
NOW(),
{Ready for Pickup Timestamp},
'd'
)
)Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
