*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automaticall…
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error mess…
Hi All, I have been tasked by my manager to incorporate SmartSheet into Teams. We have completed the integration and I can now see the shared sheets in Teams without issue. We would like to go a step …
I am trying to automate the RYGGrey ball status column, based on two date columns ([Start] and [Finish]) and 2 check columns ([Task Started] and [Task Completed]). Having trouble getting started and f…
Hi everyone! I have several projects in my time tracking sheet and would like to use the VLOOKUP formula to save only the times per project in a monthly cost table. For that I used the following formu…
I'm fairly new to Smartsheet and I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someo…
I've scoured the interweb trying to figure out how to link from my Smartsheet into a share folder using an html link, and have tried several different methods, but keep getting this error message when…
I am trying to figure a way to do resource allocation based on the number of projects a particular sub can handle at one time. We have 20-30 projects next year and trying to award bids based on capaci…
Need a way to identify tasks on my workplan where the actual lag time is different from the standard lag time. My workplan includes: 1. Predecessor column (includes predecessor with +/- lag) 2. A sepa…
