-
Countif - Want to count number of times a word appears, multiple then divide by a certain number
I'm creating a pricing sheet and need to use the countif formula. I am counting the number of times "High", "Moderate", "Low" appears in the column and times by 3, 2 or 1 then dividing it by the total count. For the sake of space, I named my column "G". Not sure if Smartsheet recognizes the "+" in the formula…
-
Newbie Question - Reports Lookup into Sheet (relational database like)
First, I am sure this has been answered, but I could not find it. I have two smartsheets: Projects and PMs. The PMs sheet has basic info about the PM (Emp ID, Name, Email). The project sheet has all the projects we are working in the company with lots of project metrics. One being Margin %. I want to create, then run a…
-
Unparseable Error
I am trying to create a formula that will return different values based on multiple factors, and the information on the sheet is linked in from another sheet my sheet is attached and the formula I am trying to use is below. Any help is greatly appreciated Here is my formula =IF([% Complete]1 = 1, "complete",),if(and([%…
-
Can I have the default value be a function?
I have a form that asks for someone's name. Most of the time, the form is for that person. There are some cases where a person might fill out the form on behalf of someone else. What I'd like to do is have a "name" field and a "on behalf of" field. If "on behalf of" is blank, I'd like it to default to the value of "name".…
-
What's wrong with my RYGB formula?
Ok, I'm feeling really stumped. I have this formula for changing the color of the RYGB balls based on the number in a specific cell but it is returning an #INVALIDOPERATION on anything except zero (when the ball turns blue). Where am I messing this up? =IF([# of Days from Submission to Assignment]@row = 0, "Blue", IF([# of…
-
Sumif WTheck?
Hello - I am trying to draft a formula to sum the column 9 but only when column 3 is "John Smith" and when column 11 is not equal to "complete." I got this far, but can't figure this out: =SUMIF([Column9]:[Column9],Column3; column3, @cell="John Smith")
-
Adding IF to a COUNTIFS
I have a formula to count based on multiple criteria which works correctly. =COUNTIFS([Change Originator Link]:[Change Originator Link], [Change Originator]@row, [DCO Status]:[DCO Status], NOT(OR(@cell = "Implemented", @cell = "Cancel"))) However, if the Change Originator (column name) for that row is blank, I would like…
-
Automated way of counting number of cell changes?
Hi all, we'd like to track the number of times a cell was edited in order to capture how many times we've moved out a date on any given project. I'm thinking this isn't possible with a formula, but has anyone found a solution with automation/integration or something else? We'd love to avoid updating this manually and the…
-
How to automatically unceck a checkbox when anotherone is checked?
Hello! So I have 2 checkbox columns, if the second one is checked the first one shouldn't be checked anymore, I tried to add an IF formula to the column specifying that argument but it didn't work.
-
Resource Check Out
Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was checked out by a different staff member? regards, Brian