Hello everyone! I've checked this page https://www.smartsheet.com/legal/limits-policy it doesn't show the storage limit not the numbe of sheets limt. I need to know this because we have hundreds of pr…
I have two formula questions. 1. I have Parent rows with a rollup formula created that takes the avg of the RYG balls of its childreen and creates a status =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", I…
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to …
@Paul Newcome @Andrée Starå I am having issues matching a cell value from my project status column. My goal is to reference my most recently updated (max modified cell) data entry and return that valu…
On a Gantt chart, I've added a column % Progress Expected and I have it calculating % progress expected per day for each line item, based on the duration; see formula below. =(TODAY() - Start@row) * (…
This there a way in SmartSheet to get a nice view of specified lines in a project plan to create a nice view? I know we can import into Office Timeline, just wondering (hoping) there is a way to creat…
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…
I have an approval workflow set based on a cell value. Is there a way to update that cell value once the approval completed? Cell dropdown example: 1. Under review 2. Sent to team 3. Ready for release…
I have multiple projects that have their respective project schedule sheets and I created a dashboard of one project. I was wondering if there was a way to make a template of that dashboard so that I …
Hello Smartsheets Friends, Using a Smartsheet for keeping track of Activation Status. Here is what I am hoping to achieve. 1-7 Days from Handover Date = Activation Call Status - Green 8-14 Days from H…
