-
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…
-
COUNTIF USING OR
How do I add an OR to the expression and logic: ="Resource: " + COUNTIF(CHILDREN(Status1:Status17), "Terminal Updated") + " of " + COUNT(CHILDREN(Status1:Status17)) I want to add both Terminal Updated and Terminal Replacement to the count. Any help greatly appreciated!
-
Functions for predecessors
Are there Smartsheet functions for enumerating the predecessors of a row? I've been prototyping SmartSheets for managing a pretty sizeable research project (multiple FTEs over several years), potentially replacing Asana for group project management. The reporting is nice, as is the combination of spreadsheet, gantt, card,…
-
Formulas for counting number of types of rows for different months/ financial years
Hi, I currently have a sheet where we follow up leads / quotes and am wanting to create some formulas, either on the same sheet or in another sheet (so user doesn't see all formulas). I have the following columns (just a few of what i have): Status (which has quotation won, quotation abandoned, quotation lost) etc. Date…
-
COUNTIF between Dates (Children) || Summary
I have a formula that is troubling me. I am trying count between two date ranges so I can count the number of shows due (between a set date ranges or set to count only the next 14 days). The forumla below is returning zero. Is it the forumnla or a setting? The screen cap below is the from the sheet I am using, hopfully it…
-
Determine RYG ball color based on rows below
Hello, I'm trying to write a formula that'll allow me to look at the color of the RYG balls in some rows, find the lowest color and set that as the main color for the overall project. So, Project A needs a status. I'd like to look at tasks 1-5; if any of them are red, the entire project status needs to be red. If any of…
