-
💡 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
-
Current User System Field
System Field that captures who the current user is so you can use formulas or logic based on that.
-
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,…
-
Sheet Banners
I was working on a sheet and before I started I knew it was going to take me all day and I had this thought that I wish I could throw an "Under Construction" Banner accross the top so people knew that the sheet was undergoing some serious changes. I felt like these banners could also communicate other useful notices to…
-
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…
-
CONFLICT COLUMN (Shows where issues are when scheduling)
I have started to develop a CONFLICT column, that is, a column to show/ highlight where the same ASSIGNED TO/ RESOURCE/ MACHINE has been allocated on the same day, thus identifying potential conflicts in the schedule. The columns counts the number of instances where the START DATE and ASSIGNED TO are the same and only for…
-
Apply conditional formatting (gantt) to parent row
Please consider developing the ability to apply conditional formatting to top level (parent) rows. It looks weird when everything below the parent is in color, but the parent is grayed out. Thanks!