-
Percent of checked boxes in summary fields
Hello Smartsheet world, I have two checkbox columns and I need a formula in the summary fields that calculates the percent of students that have both checkbox columns of "Fall 2020" and "Spring 2021" checked out of the total number of students that have checked boxes in "Fall 2020" plus the total number of students that…
-
How to make the number in my string + formula display as a percent?
I am having an issue where i have created a string plus a formula (="Percentage Complete " + COUNTIFS(Complete2:Complete11, =1) / 10 ) is there any way i can get the number that is being counted in my formula to read as a percent? i tried clicking the percent symbol while having the cell selected but since the string is…
-
MULTIPLE IF STATEMENTS - RETURNING #INVALID OPERATION
Hi I am trying to do a multiple IF statement but it keeps returning #INVALID OPERATION. I have had a search through the community and it seems that my formula is correct (it works perfectly well in Excel 😅) =IF([Date Returned]128 > [Date Furloughed]128, [Date Returned]128, IF([Date Returned]128 < [Date Furloughed]128, "",…
-
Metric Sheet, Countif value appears even once in column = #UNPARSEABLE
Hello everyone, I am trying to create a metric sheet, referencing another sheet's column. The column is a multi-select drop down, so I want to include in metric even if its one of many entries in cell. Any suggestions on why my formula is incorrect? Thanks. =COUNTIF({Sheet - TPM Request Intake KTG}:{Sheet - TPM Request…
-
How to count from a wider range by a given value in a column?
I want to count how many employees has experience of available projects, my formula is: =COUNTIFS([Employee A]1:[Employee D]5, ="YES", [Available?]1:[Available?]5, ="YES") I got an error: #INCORRECT ARGUMENT SET If I change the first condition to "[Employee A]1:[Employee A]5, ="YES"", it works. Looks like COUNTIFS doesn't…
-
Cell history and Networkdays
Hi Main issue is with the networkdays formula =NETWORKDAYS(DATEONLY([Date Submitted]@row), TODAY() - 1) Originally the formula was (thanks @Paul Newcome). =NETWORKDAYS(DATEONLY([Date Submitted]@row) + IF(AND(VALUE(MID([Date Submitted]@row, 10, FIND(":", [Date Submitted]@row) - 10)) >= 3, CONTAINS("P", [Date…
-
Adding Unique Cost of Items in a sheet of form results
G'Day All, I've tried to search, but come up empty handed! I'm building a stock control system that suits our business, and trying to work out the cost of an item (Items are in Columns) adding each time it was bought (Buy price may vary) Each row will be a form response, adding a quantity of the item bought, and the value…
-
Looking for a formula
=IF(AND([Email: I do not want vaccine]@row <> "", COUNTIFS([Email: I do not want vaccine]:[Email: I do not want vaccine], [Email: I do not want vaccine]@row) > 1), "Duplicate") The email is not always mandatory which is why I need to be able to leave blank cells alone and if there is a true duplicate I need to be able to…
-
Is it possible? Have an IF formula to check certain boxes.
I have two columns Target Age and Target Grade. Can you have a formula that will look at the Target Age column and select the corresponding Target Grade. Both of them are multiple select drop down columns. If 5-7 is selected, then check the box K-2nd grade, 8-10 is selected, then check the box 3rd-5th grade, 11-13 is…
-
Resources Tracking
Hello anyone, Please i need some help. My goal is to be able track resources and show forecast in the resource view. If I am correct. i know i have do some calculations or use formulas which i have problem doing that. The data presented to me was Title of the Resource # of people that work in June-Sept total hours worked i…