Sign in to join the conversation:
I am trying a SUMIFS formula without much success. The formula needs to return the Distance if Completed Date is before 31/03/20 and Signs has been ticked/checked.
Distance (number)
Completed date (date)
Signs (checkbox)
Is this possible?
Thanks
Faz
It is and the following works:
SUMIFS(Distance:Distance, [Completed Date]:[Completed Date], <DATE(2020,3,30), Signs:Signs, 1)
Does it work in your case?
Hi Chakm, I'm afraid not - it says #UNPARSEABLE
Hi Faz,
Chak's formula should work. Try my second one and see if that works.
Try something like this.
=SUMIFS(Distance:Distance; [Completed Date]:[Completed Date]; <DATE(2020; 3; 30); Signs:Signs; 1)
The same version but with the below changes for your and others convenience.
=SUMIFS(Distance:Distance, [Completed Date]:[Completed Date], <DATE(2020, 3, 30), Signs:Signs, 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I re-did Chak's formula and it worked. I think the issue was because the column was labelled Distance (miles) - the extra brackets were probably confusing the formula. Column renamed (without brackets ).
Thanks so much Chak (and Andree too).
Excellent!
Happy to help!
Andrée
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
