I am trying to get the Project Resource View to work. However, I am having a few issues. 1. Only one name is showing up in the Project Resource View. How do I get other people who are assigned to task…
Hi. I have four projects, each assigned to a unit division. Each project has tasks in different implementation stages. By default, Smartsheet counts how many tasks are in each stage (column). I want t…
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However…
I currently have 3 Columns: Column 1 "NUMBER OF UNITS", Column 2 "UNIT PRICE" & Column 3 "TOTAL PRICE". What I am trying to do is if in Column 1, the "NUMBER OF UNITS" is 600 or less, I need Column 3 …
My office creates schedules for our customers which are intended to provide an overall estimate of time involved to ; but not a guarantee. We would like to include a conspicuous disclaimer or splash s…
Hi everyone, does anyone have any experience with resource management of people with different availability in a week? As far as I understand, Smartsheet is taking 8hours a day for each resource into …
I have the following formula shown below that changes the Status symbol (Gray/Green/Yellow/Red) based on the Phase/Risk/Change Implementation Date. I tried to update it for a new Phase "Canceled" but …
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has…
Is it possible to do the following: Sheet (A) - A checkbox is checked in Row 4 Sheet (B) - Automatically pulls in a text-field that is in Row 4 If so, how? The purpose is to roll all "At Risk" Descrip…
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any differ…