I get #unparseable.
=SUMIFS(Effort Hrs:Efford Hrs,Assignee:Assignee,"Easton",Sprint Week:Sprint Week,"32")
Effort Hrs = Hours worked
Assignee = the person
Sprint Week = the wee it is done
In your formula, it says "Efford Hrs". I'm not sure if that's a typo in the forum, or a type in the formula itself. If it's in the formula, that would likely cause the issue.
To follow up on what Javed said, because of the space in the column name, you need to use the syntax, [Effort Hrs]:[Effort Hrs].
Great catch Joe!
Same with [Sprint Week].
In general, spaces, special characters, column names that end in numbers all require the [] brackets.
I tend to use [columname] regardless of whether it needs it or not. Smartsheet's editor will remove them if they are not needed.
Craig
Thanks, great stuff.
See attached image, it still doesn't work
D...
You still have a syntax problem...it must be [Effort Hrs]:[Effort Hrs] <--- notice the inner brackets.
Thanks much...
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
