-
IF Formula comparing SUM values
I am struggling too figure out how I can make this formula work: =IF((SUM([Billable PM Hours]@row, [Billable Consultant/Developer Hours]@row)) > (SUM([Consultant/Developer SOW Hours]@row, [SOW PM Hours]@row, 1) Intent is to have these Sums compare to each other so that when Billable Hours Sum is over the SOW Hours Sum, the…
-
INDEX COLLECT or VLOOKUP not working with numbers
I am in need of some help with trying to use either the INDEX/COLLECT or VLOOKUP functions. I have tried everything I can think of and nothing works. By employee number, I want to return their tenure. Both are contained in a reference sheet. Here is what I have tried. =IFERROR(INDEX(COLLECT({Tenure }, {Employee Number},…
-
Formula to capture last value within a column
Hi Community. I need a formula that will capture the value in a cell, from the last populated row in a sheet. Of course, the last row could be row 20, 200, 2000, thus the reason I can't point straight to it. Thoughts?
-
Years in a Rank?
What formula would you use to count how many years someone has been in a rank. For example they are hired on 11/1/10 & became a professor on 10/31/11 but was a visiting professor from 11/1/10 to 10/31/11?
-
Multiple users in dropdown formula
I'm trying to countifs a user is on target. My sheet column is a multiple selection column, some rows have multiple users selected. When I create my formula, it doesn't count if said user is sharing a responsibility with someone else. Here is my current formula =COUNTIFS({2021-2022 COMPLIANCE WORK PLAN Person Responsible},…
-
Sheet summary formulas automatically extending when new rows are added
Hi community, I have a lot of formulas in the sheet summary of my sheet. They all start like this "=COUNTIFS(Project1:Project149, NOT(@cell = "Epic Line"), [Row ID]1:[Row ID]149, ISNUMBER(@cell), ....." Now the sheet gets new rows added every day but my number 149 in the formula does not update automatically to capture the…
-
Summary Sheet calculate column totals
In the Sheet Summary section, I want to calculate three column totals. I have the below formula that is recognising the columns as 0, but if I add hours to any of the referenced columns, it does not add. =SUMIFS([Travel To Site]:[Travel To Site], [Travel Site To Site]:[Travel Site To Site], [Travel From Site]:[Travel From…
-
What is the maximum number of columns that can be displayed in a stacked chart widget ?
Hello, I need to compare data between 42 countries with a stacked column chart widget, but it seems we can only display 15 columns... ???
-
Adding IFError
Smartsheet Community Would be IF Error go at the beginning of this Formula so I do not get Invalid Value when the Cells are empty =INT((((IF(LEFT(Endtime@row, FIND(":", Endtime@row) - 1) = "12", IF(OR(FIND("a", Endtime@row) > 0, FIND("p", Endtime@row) > 0), 0, 12), VALUE(LEFT(Endtime@row, FIND(":", Endtime@row) - 1))) +…