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…
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 "Isol…
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]) …
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 differ…
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 option…
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…
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), potentia…
