Problem with Formula

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
Try changing
">=" & TODAY()
to
>=TODAY()
and
"<" & TODAY()
to
< TODAY()
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Controlling Asset Permission Levels
I have a feeling the answer is NO, but wanted to confirm. We are considering upgrading our Enterprise plan, but need to consider the significant price increase if we upgrade, so we are looking to cost structure variations based on what our users are doing in Smartsheet. We want to control the assets being shared not only…
Is there a way to start a task as soon as possible with a FF dependency?
What I'm looking to do is create a finish-to-finish dependency where the end date is extended but not the duration for a given task. This way a task can start immediatly but it may finish later than the duration. This way the duration of the task can outgrow the FF dependency but never be less than the FF dependency end…

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