-
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…
-
Nested IF Statement to Produce a Date?
I am really struggling with complex Smartsheet formula's. I am trying to produce a start date for different action items based on the below logic (also attaching a screen shot for reference): If "Isolated or Existing Market" = Isolated, then Start Date Test = (Grand Opening) - 10 days If "Isolated or Existing Market" =…
-
Formula for most recently modified among checked items only
Hello, I'm working within a sheet and want to be able to show the most recently modified date only from a set of tasks that have also been checked. So far I have =MAX([Modified Date]:[Modified Date]) This should show the most recently modified, but I'm not sure how to filter out the unchecked items (IF statement?). Any…
-
Multiple references to another sheet
Hi, so obviously if I want to have a given cell in one sheet reference another cell in a different sheet, this is easily achieved. But let's say I want cell A1 in one sheet to reference A1 in a different sheet, followed by B1 referencing B1 and so on... do I have to set these up one cell at a time??? If I try to grab the…
-
Need help using NOT in a COUNTIFS cross-sheet formula.
I think I am off my game. I cannot for the life of me figure out how to use NOT in a cross reference formula... I have a sheet with tons of data and am referencing a status column that has four options, blank, not started, in progress and complete. I want to count every row that is NOT complete. Here is what I have…
