Sign in to join the conversation:
Good Afternoon,
We are looking to figure out if it is possible to caculate time in Smart sheets. But we need to be able to figure out times for those items checked vs not checked. Is there a way to do this without sorting the sheet out?
Thanks.
Hi Ann,
=SUMIF(range, criterion, [sum_range]) will do what you need. Based on your example, this would look like:
=SUMIF([Executive Session]:[Executive Session], 1, Minutes:Minutes). So the result based on the above would be 5.
Chris,
Thank You!Follow up question. So I set that as a new row in my sheet and I made a second row to divide by 60 to figure out how many hours.
I put your formula in for Executive Session Meeting and it gave me the total, 435 minutes.
Then in the next row I put in =SUM(Minutes55) / 60Then this screens shot is the answer I got. How do I turn that into a number of hours?
You are more than welcome.
The reason you're getting an error is that we've previously set a range and sum_range that includes the entire columns. That means your new row will also be included.
Essentially you're creating a loop (circular reference) as the =SUMIF([Executive Session]:[Executive Session], 1, Minutes:Minutes) formula is trying to read the value in Executive Session and Minutes for Row 55, while row 55 is simultaneously trying to calculate a value (from row 54) that actually includes its own value.
It's all very confusing and Smartsheet is throwing out an error.
To get around this, I'd suggest moving your total formulas to the first two rows in another column (call it Totals) or even a new summary sheet. Your hours formula can also be simplified by removing SUM (i.e. =Totals2 / 60), as you're not really summing anything.
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…
