-
Reference Sheet Summary fields in formula in sheet
I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!
-
Removing Zero Values From Chart
I am trying to create a stacked column chart to show how many Statuses are being used per section (Section for Chart) in a project plan. However, I do not want any zero values to show. I have attempted to create a report for this chart, but I cannot get the chart to look the way that I want. What I want (minus the zero…
-
Update Request Improvements
I would like to suggest: The option to "Include Parent Rows" when sending Update Requests (similar to the option when creating a Filter) in order to provide the context for the row in question. Include a link to the sheet in question from the Update Request Form, not just the email. Automatically include the Row Number/ID…
-
💡 Gantt w/Connected Dependency Slider Rows
A Gantt view template that duplicates rows with sliders to see what dependencies slide (out/in) when a date changes on the duplicated slider tasks. This helps with real time discussions for a visual dynamic work back or determining critical path impacts and overlaps.
-
Concatenating values from two columns with 20 spaces between them
Hi guys, I have a task to concatenate two strings from two different columns with formula. The values are for example SEA129 and 01. What I want to achieve is a string which will look like this "SEA129 (20 blank spaces) 01" Has anybody encountered similar issue?
-
How to calculate time in smartsheet
Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00
-
Ability to hide row conversations/comments and/or attachments on published reports
Reports are great for sharing specific information from teams to leadership or external partners. However, it is a huge limitation for published reports not to have the ability to hide conversations. Conversations are a great feature for internal teams to be able to communicate on specific line items within a sheet, when…
-
Suggested Sheets - Update more frequently or in real tme
I notice when I update a sheet, and it appears on my suggested sheet, the preview is not updated. I was told that only occasional screen grabs are taken, and it looks like my sheet is not current, when in fact, it is, giving me problems with the boss.😫 I think the suggested sheets should be updated as well, in real time,…
-
Merged: Sheet Banners
This discussion has been merged.
-
Message: Your Smartsheet session is no longer active
I'm getting this message "Your Smartsheet session is no longer active" - which I don't mind - however, I'm getting it after I start typing or updating data. I get the message, the sheet reloads and added data is lost. It's happening in a variety of sheets, not just one. It's been happening for a few weeks. Is anyone else…