Hi All,
Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not.
Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1)
Co-workers fill out the form and entries are collected. I added an "AUTO-NUMBER/SYSTEM" & it is set to [ Created Date ]. <--- I need to tally these entries by months so I can create a dashboard with a line chart showing the trend of entries. See below:
In the Sheet summary I have this: =COUNTIFS(Created:Created, IFERROR((@cell), 0) >= DATE(2021, 11, 1), Created:Created, IFERROR((@cell), 0) <= DATE(2021, 11, 30))
This formula works for entries for Sept, Oct, Nov, Dec ONLY
--------------------------------------------------------------------------------------------------
Months April, May, June, July were pre-Smartsheet...
I do still have the Google Date created column set to "DATE" . I changed the formula and get a " #UNPARSEABLE " Error. Using formula: =COUNTIFS(GoogleForm Created Date:GoogleForm Created Date, IFERROR((@cell), 0) >= DATE(2021, 5, 1), GoogleForm Created Date:GoogleForm Created Date, IFERROR((@cell), 0) <= DATE(2021, 5, 31))
Any ideas? 😥