Hi @Amy_Asch,
You can just pass the result of your first formula into the second formula –
DATETIME_FORMAT(
WORKDAY(FirstPerfor, -2),
'MM/DD/YY-ddd'
)
As far as drafting formulas with a text editor goes, using a text editor geared towards writing code is going to be the most useful, because it will auto-create closing parentheses, brackets, quotes, etc for you, and will auto-indent nested lines for you. There are several good options out there for lightweight coding text editors, so just do a google search to find one. I use Visual Studio Code myself, but it’s not the most lightweight option.
After you’ve chosen and installed your editor, simply create a document (usually ctrl/cmd+n while in the code editor) and you can start typing your formulas. Sometimes, making the most of auto-formatting will require saving your file with a language extension (a coding language) – the extension tells the code editor to treat the text in the file as code in the language the extension specifies. Try either .cs or .py – those are the two I’ve found most amenable to writing Airtable formulas, personally. So if you file was named new_file.txt to start, just rename it to remove the .txt extension and add .cs. or .py – so your file will now have the name new_file.py.
Now you can just write your formulas in that file, and then copy paste them into Airtable.
