I am having numerous challenges with the Resource Views and not finding them particularly useful. I only want to see resources for particular sheets, my preference would be to select a workspace that …
We use smartsheet as a CRM/Project management. Each Row is a new project we are quoting. In the rows we have over 25 different columns. The way we usually view and enter data in them is in card view. …
I'm trying to answer some questions on why the Project % Complete values are what they are, in greater detail than what is provided in this help article (which just indicates that it is calculated by …
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the num…
Hi! I am trying to find a formula to check a box Done when several other cells are checked done. Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done. My If Then formula do…
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blan…
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this someth…
Hey Smartsheet Community, I am really not that great with making long formulas, especially with the "IF" formula. Could someone please help me with making a formula for the RYG balls where if the task…
