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
I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is =IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row ))) but instead of returning the value it says #INVALID COLUMN VALUE Got it working…
Hi all. My team is currently using a sheet to track tasks and hours spent on each task, for each week of the month. There are 4 different types of tasks (Project, Initiative, Ad Hoc, Daily Task), and some of out project managers work on the same project or initiative. I am trying to create a COUNTIF formula to count the…
Hi Community, I'm looking for assistance with creating formulas in Smartsheet to separate a combined DateTime value into two distinct columns: one for the date and one for the time. "Date" Column: Contains both date and time values "Date Only" Column: Should display only the date "Time Only" Column: Should display only the…
