-
Resource management
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 consideration. Thanks for any help. Pavla
-
Automated Status Ball color change
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 keep getting the error #UNPARSEABLE. Is this due to the fact that I'm trying to have both the Phase "Operationalize" &…
-
Average of lease $ amounts in a certain region
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 been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Is it possible to have Sheet A populate information into Sheet B if a checkbox is checked?
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" Description Fields into a summary sheet for the executives to review. Reports won't work for they need to be able to type their…
-
Sorting Issues
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 difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
Numerous issues in last few days
Have others been experiencing any unusual activity in the past few days? I have been having a number of issues that appear to be related to permissions and reports e.g. A report we use daily suddenly showed a permission error for one of the users in the team although their permissions have not changed and they are owner of…
-
COUNTIFS and with 2 different values in same column?
Hi there, I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete". I've been trying different ways to organize COUNTIFS to solve the problem, but I'm getting either "0" or #Unparse as a result. The most straightforward formula I've…
-
Project Status Reports
Hi All, In our PMO function we are looking to create project status reports in Smartsheet that would be a 1 page for a PM to update RAG, finance outlook, comments etc. We would have 1 sheet per project, that we could then roll up into a report and query in Tableau for board reports. Has anyone got a good example of this…
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
