-
Rounding percentages in sheet summary
I am looking for a way to use the percentage number format on sheet summary and to be able to round the percentage to a whole number. I have tried adding ROUND to my formula but this just populates the field with 0 as the calculation to convert the number to a percentage happens separately to this. These fields link to a…
-
COUNTIFS Question
Hi all, I'm working with the formula below - =COUNTIFS({CXAO JIRA Range 1}, "Open", {CXAO JIRA Range 2}, "Change") I need to know if it's possible to add multiple criteria for the where "Open" is listed? I need to bring back a count of several statuses Open, Backlog, etc. all while meeting the second criteria" of "Change".…
-
Sheet Summary - Countif - #Invalid Operation
Hi all, Ok I am going crazy, hope someone can tell me where I am going wrong: I keep getting #Invalid Operation on a sheet summary Countif Formual based column "Days to Obtain PO Range" - This column had a formula in it I have a second column called "Test" - this column has the same formula as the above Why am I getting a…
-
Join Collect with collecting data from Multiple cells
Hi, I have six "issue" columns and six "resolved" columns. I'm trying to collect all the Issue columns into a final column. I'm using the following formula but I'm getting #INCORRECT ARGUMENT SET =JOIN(COLLECT([Issue I]@row, [Resolved I]@row, 0, [Issue II]@row, [Resolved II]@row, 0, [Issue III]@row, [Resolved III]@row, 0,…
-
Using IF and isblank function to print column value
Hello, I am new to smartsheets and am having a little difficulty getting my spreadsheet to print the actual column value when using if and is blank. I have two columns: a request by date (manual) and due date (automatic). The formula should first read the request by date column and print that date if there is a value…
-
Sum Ifs Formula
Hello, I was able to create a formula to reference a sheet and calculate total activity cost per month: =SUMIFS({May}, {Activities}, CONTAINS("Book-in", @cell)) Results are the total cost of activities that contain 'Book-in'. However, when I tried to recreate this formula and reference another sheet, I get incorrect…
-
VLOOKUP Query
Wondering if someone can help.... I have two vlookups, both looking at the same source sheet and the same search and return values, only the search and return values are switched. So where on one the data is the search value on the other its the return value and visa versa. As you'll have guessed this poses a problem with…
-
Dashboard Carts
Hi Smartsheeter's, Please help me figure out how to display a widget on the Dashboard that would show the general state of several projects of the program in the form of a pie/doughnut chart. SmartSheet issues a message - Invalid Data. To create a chart you must use numeric data. As the next step I tried to create…
-
RYGG formula does not work the same for all rows
Hi Smartsheeter's Please help me figure out what the problem is. I am using the formula to show row's Status: = IF (OR ([% Complete] @row = 1, [Start date] @row> TODAY ()), "Green", IF (Status @ row = "Not started", "Gray", IF (AND ([ Due date] @row> TODAY (), [% Complete] @row <0), "Gray", IF (Status @ row = "At risk",…
-
Count Hierarchies without including dupes
Is it possible to count the number of the hierarchies? Right now, I'm using the count function and manually clicking on level 1 for those counts and level 2 for those counts. My document is rather large and I don't want to click through each one and someone may insert a new level and I don't want a break in my formula. The…
