-
Matching a percentage dropdown entry
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 completed tasks (ie any cell with 100%). I imagine this is pretty common. However, the cell type doesn't seem to be textual, nor…
-
Formula help
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 lines) The top line is the grandparent line the white rows are the children. So what you see is each children row has some…
-
SUM more results from more IF conditions
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 * M - 5 points * N - 8 points I need to have in a single cell the sum of the score of a gruop of question. Have you any tips…
-
If(AND) across a range
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 of the cells , for example: =IF(AND([Map Complete]18= 1, [Map Complete]19 = 1, [Map Complete]20 = 1), 1, 0). When I do it…
-
Unparseable Error in IF(And formula
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 can ultimately send an update request to the user to fill in the notes field. I haven't used the AND formula nor have I…
-
RYG formula based on % Complete
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, but I'm getting a Unparseable errors. **Note, I'm trying to enter the formula into the Status column on row #5, figuring I…
-
Cell References
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, basically retrieving different cells from that one "Test Sheet" -- the reason why I want to do that is so I can just copy/paste…
-
Countifs by Month
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 tedious when you're just looking for what happened in a particular month of the year. Regards Steve
-
Formula: If Status Changes to Something After Date
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 neighboring cell turn red (after a certain time and date- the time and date of which I input the formula), but not if they were red…
-
Turn off Auto-Save on Android App
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 untill it has saved. is it possible to turn this off, and maybe just save it when required, or when you leave the sheet or…
