- Rich Text formatting in cells
I would love to see rich text formatting be available in cells on a sheet. We have several reports where we rely on certain words in a cell to be a different color than the other words in a cell (quickly showing variable options or redlining changed content if only a word or two has been altered). Currently, we are only…
- 计算日子
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
- Data doesn't match the data from Excel when replicating formulas
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to be a number of discrepencies with some of the data where it is out by a few thousand pounds or a couple of percentage…
- Blank rows added after a new entry is created through form, why?
Why is it that it keeps occurring to me that when I get a new row of information (populated by a form) about 10 additional BLANK rows get instantly added on my main sheet? I have to keep deleting this manually and it's just adding a ton of manual work. Any explanations, solutions to this?
- Unexpected movement of rows - older post recommendations not working
I read an older post from someone else on this issue, but despite our best efforts, rows jumble unexpectedly and its such a significant problem we might not be able to continue with smartsheets. Here's what happens - we have a shared sheet showing our project schedule. Each project has a line and there are dependencies set…
- Merge cell functions
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
- Create dynamic custom schedules based on selections in intake
Hi all, I recently developed a cool solution to an issue that we had... how to build a custom schedule based on selections in an intake form. This solution leverages Bridge, but you could do the same thing using a third party integration tool. THE GOAL The process goal for this solution is: Collect project requests using…
- Save as new//100 sheet limit - work around?
你好,Does anyone have a workaround for this? I have a client where i have stripped the workspace back to around 150 sheets - they need to be able to replicate this workspace. I'm getting the same error message when trying to copy the workspace via the API - The end result means that due to this limitation, someone has to…
- Sheet Templates
I'm new to the Smartsheet Planning group for our team so I'm coming in after years of them doing things a certain way. I'm trying to find a more efficient manner to manage updates to master sheets instead of rolling them out quarterly as we've been doing. Essentially every quarter we pull all feedback, make updates to the…
- Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
