I have a project plan that I am now updating to establish dependencies. Everything was going fine until I updated one task's predecessors and a completely separate row's dates (and associated span in …
Hi, I have a folder with several documents (reports, project plans, etc.) and they are all linked to various different sheets in different workspaces. I accidently saved the folder as new, but I selec…
Hello, I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work. In a new sheet, I want to return the value of a specific c…
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Prima…
Currently stuck trying to automate the completion of one task to trigger the next. The situation: All data is on one row per project. Each task is listed there and on its own sheet. And everything nee…
I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell. Below are two columns. The right column adds a "|" to the value in the left column. You can see t…
Regarding the question above, consider a scenario where 1 project requires 2 linked smartsheets. Now consider a scenario where 50+ projects each require 2 linked smartsheets and a new project is added…
I am trying to return a Contact value Cell from a lookup table, in the Column "Assigned Contact Email" according to "Week * + Day*" and "Shift Assigned To" in that Row This is what I want it to look l…
Hi all, I am trying to update an existing metadata sheet in our solution build via SCC. I was able to make the changes on the sheet itself and have applied it at the template and test with an existing…
Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin…
