Spruce - profile

Spruce · Nov 09, 2023

Hi all! I am back looking for support with a formula to return a date based on a "created" date and a variable.So far I've been trying to get an IF statements with a DATETIME_FORMAT included to work, but I'm making no progress...My Goal: Create a col...

Spruce · Oct 30, 2023

Hi All! I am trying to work with the DATETIME_DIFF formula but running into some issues. I am assuming the issues come from time/timezone complications, but not sure what the most elegant way around it is...My goal: I am trying to calculate the diffe...

Spruce · Oct 16, 2023

Hello! I'm slowly learning how to use date formulas, but I have hit a wall in my ability to troubleshoot.I have two date formulas causing me trouble.1) My Rush Due Date is displaying #ERROR! when "Rush" checkbox is not checked.DATETIME_FORMAT(IF(Rush...

Spruce · Oct 05, 2023

Hi All! I am still new to Airtable and writing formulas and (hopefully) this is an easy question.I am trying to write a formula that will display text that matches the "checked" state of 3 different checkboxes, and also will display "New" if none of ...

Spruce · Sep 29, 2023

I 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:If the Completed column checkbox is ticked, display "Completed"If the checkbox is not ticked, display the time...

Spruce · Nov 27, 2023

Hi @Anna , thank you so much for helping us solve this. I am having an issue though. The image shows up, but the link doesn't work.This is my version of your suggestion, what am I getting wrong? <img src="https://sprucecircularity.com/assets/images/i...

Spruce · Nov 09, 2023

I figured it out! Asking the question helped me realize what the solution was!For anyone else, here's @stevendasilva 's formula with the addition of DATETIME_FORMAT:DATETIME_FORMAT(IF(Rush,DATEADD(Created, 6, 'days'),DATEADD(Created, 11, 'days')),'ll...

Spruce · Nov 09, 2023

Oh man thank you so much @stevendasilva for the quick reply! Your suggestion is perfect. The only other thing I'd ask, if you have the time, is if there's a way to format the output without the time and in a "friendly date" format (i.e. Nov 9, 2023),...

Spruce · Nov 09, 2023

Hey @kuovonne , yeah I think you're on to something with all those thoughts. I had always heard from developers that date and time-zone stuff is some of the trickiest they deal with and now I see why!Thank you for your support!Devon

Spruce · Nov 09, 2023

Hi @Arthur_Tutt , yeah that's right. Although there is some other funky stuff going on too... Unfortunately I can't change the time on that first "estimated pickup date" since it is being generated by Fillout.Adding the +1 to the calculation is smart...

User Statistics

User Activity

Formula to return a date based on a "created" date and a variable

DATETIME_DIFF challenges

Help! Trouble with date formulas #ERROR! and NaN

Nested IF plus.... What else do I need? 😳

IF + DATETIME_DIFF Formula Help! 🙏🏼

Re: Is it possible to have images in automatic emails?

Re: Formula to return a date based on a "created" date and a variable

Re: Formula to return a date based on a "created" date and a variable

Re: DATETIME_DIFF challenges

Re: DATETIME_DIFF challenges