Hi, Does any one know if there is a way to auto up date a subtasks dates when you move the tasks between parent tasks? The scenario is we have a course booking tracker and the PARENT task is the cours…
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Sma…
Hello all, I am trying to make a spreadsheet that tracks employee fitness reimbursement balances based off of their entries into a form. Each employee has exactly $300 that they can use per year for f…
Hi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the change…
I've created a sheet to build metrics from a very large source sheet. I'm trying to count based on the following: the column {Module 3 - Section Owner} matches a cell in this metric sheet in the "Prim…
Good afternoon, I am trying to create a formula that searches 2 cells with a row, and if both are blank then it will return "Online", but if either one has a value in it then it will return that value…
Hi I'm trying to make a inventory with a reference from a another smartsheet sheet, but since im kinda new into Smartsheet I dont know which formula I need to use. Its a hole Row from one sheet and th…
Hello, I'd like to create a list of Projects that acts as a source to update downstream teams. See the attached image as an example of column headings. I'd like this list and its contents to be availa…
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a co…
