-
How to show the actual person who added information to a sheet
In smartsheet, you have the Created By and Modified By autonumber system properties. If you have created a web form, any responses provided via the web form reflect "web-form@smartsheet.com" in those columns. Is it possible to get the actual persons email who submitted the information via the web form reflected there…
-
Help: Using =IF and Replace
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignment]50) matches cell's information. I'm lost on how to make this happen, and hope the solution is simple. I have a limited…
-
Problems with LOOKUP formula
Hello, I'm encountering an issue with the LOOKUP formula in Smartsheet. Apparently it doesn't work with the names that I use in my lookup range (note that I dragged the formula down to the bottom, using "$" to block the rows of the range, but I get no results): I would like to understand why it is not working and if there…
-
portfolio roll up - Waterfall and Agile templates
Hi, I use waterfall and agile methodology as per project requirement. I am creating a portfolio master roll up report for executives. When I pull all the projects, it pulls only waterfall templates ( yellow row). How do I make sure it pulls agile projects too( organe row)?
-
Color Formatting
I have been noticing that my color formating occationally changes. I have one sheet I am working on that I color cordinated parent and children rows. Frequetly while editing, expanding and collapsing row, some cells will revert to white. Is there a reson for this, something I am doing wrong? Or a way to prevent it?
-
How to calculate effort relative to working hours?
As a new user I'm working my way through the Smartsheet product. Thanks to the 'best answer' in this post I was able to calculate the Effort (or Energy), which is visualized by 1 to 5 people-icons; this way Duration can be set or calculated for regular project planning, but in Card View this is automatically shown by an…
-
When will the API get some attention?
I'm using the smartsheet library, and it works pretty well, except that checkboxes always return None, no matter the value. I submitted a bug to the repo on github, and linked it to some other folks that noted the same problem on StackOverflow. For the tool I'm trying to build, I really need that feature to work, or at…
-
Feature Request - Combine row with discussion in notifications
Could not find this in the forum. Hope it's not a reapeat. So, we use SS to track multi-room multi-year projects with 10-15 people reporting on a site per day. As each person may work on several rows that day, there will be changes to the rows and changes to the discussions. Then, when the daily report comes out and you go…
-
Lead time Formula
Hello, I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and in another cell we would…
-
New Client Sheet Generator?
Hello, I have a Web Form which Account Managers complete when a new client is to be added to a 3rd party tool. This data transfers to a smartsheet where an email is sent to our 3rd party tool notifying them there is a new client. This data contains the client name, address, phone, email, and POC. At this point, I am…
