-
I need a formula to return the most common value in a column.
I need your help to create a formula to return the most common value seen in a column. I have a dynamic list of Names and I want to display the name that appears the most often in a Summary field. Mental block, sorry! I've seen very similar posts but nothing has worked. From this example, I want Joe to be displayed.
-
SUMIF with checkbox condition
I need help writing a formula to apply a mark-up percentage if the checkbox is applied. Annual revenue is sum of date range. If checkbox is activated, then 1.5% is added to the sum. If no checkbox is present, then it is just the sum of the date range. thanks for any help.
-
Looking to get some insight on a formula
Trying to write a formula so that if A is no then B would be complete and if A is yes then it would be Not Started, I would still need to have the functionality of the drop downs for people to use. Cant seem to find the best way to do this. Any help is greatly appreciated.
-
formula for status column using symbols based on end and target dates
Hello, I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like: If end date is not past target date then status is green If end date is past target date then status is red Could someone help with the formula? Thank you in…
-
Can I SUMIF with the vlookup cell data?
I have: File 1: cell 1 is populated with a number via a vlookup formula in that cell file 2: I want to sumif the data in file 1, cell 1. Will SS be able to do that calculation? Will it see the numeric value in the cell or will it give an error as it only sees the formula?
-
COUNTIF based on a Sheet Summary Cell w/Formula?
Hello! I am trying to create rolling metrics of how many entries we have in the current Fiscal Year, Quarter, and past Fiscal Year. How would I reference a Sheet Summary cell's value? For ex, I want Total Orders of Fiscal Year to show me everything in FY23. My Total Orders of Fiscal Year cell has the formula-…
-
How do I make a word in one column equal a dollar value in another column?
I’ve tried the the IF formulas but can’t seem to get it right. This is the formula I’ve tried after reading some answers from another question, but I receive #INCORRECT ARGUMENT SET. =IF(CONTAINS(“NEW”, [New or Reload]@row, “$400”, IF(CONTAINS(“RELOAD”, [New or Reload]@row, “$200”, “”))))
-
Formula to create a round number
Hi - I have this current formula in my summary sheet, what do I need to add to it to create a round number? =([Task Status Complete]# / [Total Tasks]#) * 100 Thanks!
-
Apply formula to full column
As lines are constantly added in a workinglist, I want to ensure any new lines will always have a column with a formula filled in. The formula will check certain data in fields on that line to show a specific status/value. I read that i should be able to 'insert' a formula on a full column, but can't find it. I'm only able…
-
How to countifs "<1"
Hi Smartsheet Community! I have a calculation sheet and I am using COUNTIFS to pull the count of each option in a range of <1,1,2,3,4,5. These criteria were not chosen by me and must remain as is. I am easily able to do this for 1-5 but Is it possible to use COUNTIFS to count how many "<1" there are? Is there a better way?…