-
New Smartsheet Solution Category: Project Management
Hi Smartsheet Community, We’re excited to announce the release of our new Project Management Solutions! The Project Management Solutions includes 5 categories, each with a bundle of templates and a detailed how-to guide based on best practices from experienced project managers. Take a look at the different categories we…
-
Adding the business tools
Why couldn't I add business tools? Do we have to buy each? Or do I have to work with my administrator?
-
Gantt Chart view for Daily / weekly / monthly Scheduled works
Hi all, We are new to this amazing product. We have separate 9 sites that have numerous different types of scheduled maitenance required at different times. Is there a clear way of displaying this in a gantt chart or spreadsheet type of format? example - Daily clean, weekly service, monthly polish, yearly audit. Thanks in…
-
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)?
