Hoping you can help! I'm trying to setup a formula where if I have a Red RYG ball in a cell of a task row then the comment next to it copies into a different cell (on the same sheet) for reporting. I …
I want to if assigned person is correct to then take information from one cell and transfer to a different cell automatically? This is the formula I have so far however when I enter this it gives the …
We are trying to achieve a formula that finds the most current Tracked task's Variance from the Baseline date. Tasks are arranged in a table/schedule in step by step order. I'm having an issue with th…
Hello all, Maybe simple question, but I would like to have the a cel inside a smart sheet filled with the filename of the sheet? How can I do this easy? e.g. CLIENT-001-sheet011 in a cell? Thanks, Eri…
Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where simil…
I have several sheets that contain course development information. Some of the information is private and not intended to be shared . I created a report for a vendor that pulls information from one sh…
Is there any updated information for linking cells between sheets with the new UI? It looks like the direct way is still in tact (where you right-click on the destination cell, click on "Link cell fro…
I have a sheet with all the data I need for reports, dashboards and other summary sheet. My trouble is, whenever I add a row in the source sheet, it is not reflect in my reports. Example, I have a rep…
I'm almost certain that there is no solution to this situation, however, here goes. I have a workspace with approximately 35 project sheets. Each project has approximately 50 tasks and each has a sche…
Hi, I have multiple projects to be managed under a program. I have a task1 under Project A which has dependency on task2 of Project B. How can I mark dependencies between two project tasks? thanks, Pr…