-
PMO Use of Smartsheet
Hi, Has anyone successfully used Smartsheet for a portfolio of projects? In particular, we are being asked to track dependencies between projects and to be able to produce a high level gantt chart across multiple projects. Thanks!
-
Notification problems
I was trying to have a notification sent to the "Responsible Party" assigned to that cell so they would receive an email when the row was assigned to them. It seems straight forward but it is not working for me. (I used another email address I have as the responsible party for testing purposes) what did I do wrong?
-
Add a row to an existing update request
Is it possible to add a row to an existing update request. I have a sheet that allows users to select an update frequency (i.e weekly, monthly & quarterly) for their initiative via the webform they use to load the initiative. What I would like to achieve is to set up an update request for each owner (weekly, monthly and…
-
New! Row Edit Multi-Pane View - will this help your SmartSheet efficiency?
Hi, why always separately open the multiple edit dialogue boxes for data linked to a row -when you could have one click optionally open all all simultaneously in a Multi-Pane popup window! - Row Edit, Discussions, Sharing, Attachments, (PLUS even a new feature - part of the multi-pane window showing an email thread linked…
-
Form - fill requestors e-mail address (or name) automatically
I'm creating a request form and want to fill requestor's name (or e-mail address) automatically so that requestor doesn't have to fill out by him/herself. Can we do it? I see "contact list" as column type, but doesn't look this offers what I'm looking for. I looked around Formula/Functions but don't see similar functions.…
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I…
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
Problem with SumIF
Hello @Craig and other Helpers i experiment the same issue than other sorry for my english but i m french i copy your formula below and try to adapt with "laserjet" type i want to make a sum if a name appear in the row i write it but doesn t work =SUMIF( [Syndic]1: [Syndic]1132]; FIND("Crouzet"; @cell) > 1; [Total…
-
Search through Symbol Column
Hello, I am trying a formula to search through my Symbol Column and get back a Symbol, if there is the same Symbol in the Colums: I am now trying with: =IF([Eskalation]:[Eskalation] = "Extreme"; "Extreme"; "no Extremes") it shows me that the formula is wrong. Anyone has any idea why? I just want to have a Cell at top, that…
-
Auto-Increment Change Orders
I have a column [Entry Type] which contains (Task, Change, Other). I use a web form to allow others to enter change orders. I would like to automate naming these change orders as Change Order 1, Change Order 2, Change Order 3, etc. I can use =COUNTIF([Entry Type]:[Entry Type],"Change") to obtain the number of change orders…
