-
Re: Stumped on an Unparseable formula
In the one that doesn't work, you are spelling out "Account", but in the one that does work you have it abbreviated as "Acct". Make sure whatever is being used as the column name …1 · -
Re: Adding One More Criteria to Working COLLECT Formula
Double check your cross sheet references are all of the same size and shape. Sometimes things can be a little slow on the back-end and change a full column reference to a single cell reference if you…1 · -
Re: Invalid Value Error on Dates (even when the column types are all DATE fields)
Here is another way of doing it that may be a little easier to modify. =IF([Affiliation Date]@row <> "", IFERROR(DATE(YEAR([Affiliation Date]@row), MONTH([Affiliation Date]@row) - 6, …1 · -
Re: Need a conditional formula to automate status column based on values in date columns
Another option would be along the lines of... =IF(ISDATE(End@row), "Complete", IF(ISDATE(Start@row), "In Progress", "Not Started"))1 · -
Re: Pause "Days in Progress" counter
Building off of the two date columns for on hold then off of hold, you could just do a basic subtraction of the two dates to get the duration of on hold and then subtract that from the final result o…1 ·