Sign in to join the conversation:
I am using this formula to Sum all values except for the ones assigned to "External"..It still adds these hours. What did I miss?
=SUMIF([Resource Type]:[Resource Type], "<> *External*", Hours:Hours)
Hi Gwen,
Try something like this.
=SUMIF([Resource Type]:[Resource Type], <> "External", Hours:Hours)
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
It does.....thanks...You too
Excellent!
Happy to help!
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
We run our project delivery sheets in Smartsheet and are required to present them to clients on a monthly basis so they can see status updates and timelines. When we print to PDF, it reduces everything on A3 to tiny print and the client has to increase the view to see what is written. One of our clients uses another…
