-
Question about the link from cell in other link
I want to make a link : There is one main sheet and a minor sheet. I want to link from the main sheet to the minor sheet. But if I add one column or row in the main sheet, the minor sheet will not update the new column or row? How to make tihs???
-
Where is the button of merge cells? Can we make some columns the same name?
Thanks for developing this app. This is a good point. But I think we need some necessary function like excel. such as merge cells ... And i find that i cannot name more than one columns with the same name? When I try to import excel sheet, there even a limitation. I have to split my worksheet? Takk
-
Spreadsheet data source
I have a spreadsheet that automatically pulls in data on projects that my global team is handling. I have not been able to figure out if I can link this spreadsheet to SmartSheet. The reason I would like to do this is that this spreadsheet automatically pulls in new project requests down from SharePoint. Please let me know…
-
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…