Formulas
Discussion List
- I've got a pretty simple requirement which I'm struggling with. I have a dropdown defined with % values for completion (ie 100%, 75%, 50% etc) and I want to create a formula which searches for complet…
- Hello, I have been trying to work this one out. Attached is a picture of the column that i wish to tally. This column is a checkbox column and there are multiple parent lines (these are the colours li…
- Hi All, image different questions (1 for each column) with 3 possible drop-down answers (Yes, Maybe, Not). Every combination question/answer generate a different score. Ex: Question 1 * Y - 3 points *…
- I have a hierarchy of checkboxes. I am trying create a IF(AND) formula to at the Level 1 checkbox to be checked once all the Level 2 boxes are checked. I am able to make it work when I reference each …
- I'm trying to create an IF statement that relies on the data in 2 cells. Basically, if one cell is checked off and the other is empty, I want to create a formula on a new cell (which I will hide) so I…
- I'm trying to create a formula that will automate the RYG balls (red, yellow, green) based on the project's % Complete. Green = 100% Yellow = 50-99% Red is = 0-50% Below is how I wrote the formula, bu…
- I'm trying to reference a sheet using a cell value, but it doesn't seem to be working. Is it possible? Cell Value: "Test Sheet" I want to reference different rows based on the first cell value, basica…
- I am familiar with =COUNTIFS({Start Date}, >=DATE(2018, 10, 1), {End Date}, <=DATE(2018, 10, 31), {Classification}, ="Lost Time Injury") Wondering if there is an easier way to get this? This is pretty…
- I'd like help in creating a formula that depends on another cell changing to a specific status, not if it is that status already. E.g. to have a checkbox get checked if the status balls of a neighbori…
- Is it possible to turn the auto-save function on the Smartsheet Android app 'off'? When our guys use the app on their tablets when they have a weak connection, after each cell there is a long wait unt…