Problem with Formula

Options

fortiz333

fortiz333 ✭

04/18/24 in Smartsheet Basics

What is wrong with this Smartsheet formula? Getting Unparseable. =SUMIFS([Car Count]1:[Car Count]39, [Expiration Date]1:[Expiration Date]39, ">=" & TODAY(), [Expiration Date]1:[Expiration Date]39, "<" & TODAY() + 365)

0 ·

Answers

KPH ✭✭✭✭✭✭

04/19/24
Options
Try changing
">=" & TODAY()
to
>=TODAY()
and
"<" & TODAY()
to
< TODAY()
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Filter for comparing dates
Trying to create a filter to only display rows when dates in "Max Obtained Date (LW)" column are greater than dates in "Max License Status Date (NMLS) column. Any ideas?
Read cell with comma as a number/value
Dear all, I have a column with numbers that can contain a comma. I need to do a sumif on this column, but Smartsheet reads this column as text, and therefore my formular does not work. I have tried different ways to convert the column to a number in another column, but I have not managed to find a function that works. I…
Suggestions for multiple file uploads?
I'm looking for suggestions on the best way to create an intake form that would allow external users the ability to upload documents in our system. The idea is that internally we would be alerted when documents are uploaded, review and approve them. External users may need to upload 15 documents. Any suggestions?

Help shape the future of Smartsheet.
Share your ideas and feature requests.