Kitty_Matz - profile

Kitty_Matz · Oct 03, 2023

I have a field with a formula that calculates total days using this formula: IF({Status ✏️}="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'), "N/A")The formula works, but returns results of 1, 2, 3 etc., which when i try to use this col...

Kitty_Matz · Nov 22, 2022

Hello, I have searched the “ask the community” and the FAQ and am not finding the answers. I am able to set up the trigger for automations, but I would like to be able to do two things in the action of sending an email. 1.) I would like the email to ...

Kitty_Matz · Nov 09, 2022

I have this formula WORKDAY({Release Date},-{weeks out in #days}) it returns the date that I need but if there is a cell with Release Date empty, it returns #ERROR. I have tried this formula IF( AND( {Release Date}, {weeks out in #days} ), DATETIME_...

Kitty_Matz · Oct 04, 2023

That was it - thank you very much.

Kitty_Matz · Nov 23, 2022

thank you, Ben. it is not a weird question or explanation at all. yes, I test every time I add a new component or variable. For the trigger portion i do one step at a time to make sure that Airtable is grabbing the data that I want, then once I get t...

Kitty_Matz · Nov 09, 2022

I got it from other community chats: IF( {Release Date}, WORKDAY({Release Date},-{weeks out in #days}) ) thank you Jeremy Oglesby!!

User Statistics

User Activity

Need a field that reflects a number beginning with 01 based off a formula in another field

Adding a field in a message body in automations

Formula works but returns #ERROR on blank cells

Re: Need a field that reflects a number beginning with 01 based off a formula in another field

Re: Adding a field in a message body in automations

Re: Formula works but returns #ERROR on blank cells