-
Saving over other entries
I know SS will tell me when another user is viewing the tab, and it will tell me when they make changes so I can refresh. The challenges we're facing are: there's a good 30-45 seconds before SS tells me that someone is viewing the tab. That's plenty of time for them to get in, make a change, save it, and have me save what…
-
Newbie please help - is this possible
Hi there I'm new to smartsheet and I'm wondering if the following is possible... I'd like to have a template waiting in smartsheet. I'd like to setup a Google form, when its populated, it would automatically be forwarded to smartsheet, as it arrives a new sheet is created based on the Template I created previously. I would…
-
Schedule Cell Linking w/Lag
I have linked multiple project schedules together, but I'm wondering if there is a way to add lag time between the links? Currently the finish concrete completion date of the first becomes the clearing and grubbing start of the second, but I'm wanting to add a one week lag time between the two while keeping them linked.…
-
Automatically linking cells/sheets
I want to create a sheet that will automatically add any task that has been assigned to me in other sheets. Is it possible to set this up so it will happen automatically? I would like to avoid having to manually add every new task I am assigned from every project I am working on. Ideally I would like to set this up for my…
-
Percent Complete not adding up
I need some help figuring out how to make my "% Complete" column reflect the actual percentage using my "Hours" column and not "SLA" (days). The sample below is clearly incorrect. It should be more like 64% complete. I'm totally stumped.
-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
JIRA Integration: automatically fill in "Start Date" when a Status has been changed?
Hi Smartsheet Community, We've integrated JIRA into Smartsheet. We're looking to automate some more fields. When using the gantt charts, some of the field we are manually filling are and Start Date and End Date. Is it possible to accomplish the following? 1) When a JIRA [Status] has been switched from To-Do --> In Progress…
-
Sheet Name in Task Name
Is there a way to display the Sheet Name in the Task Name or do I have type it in for each task?
-
Collapsing rows on report
Good day, Is it possible to collapse rows on a report? Y
-
Misaligned Selected Box in Smartsheet - GUI
Hi, I have noticed the following after using smartsheet on Windows7 and IE 9.0. It looks like the selected box is mis-aligned which is offset from the box that youa re typing in. I have to switch to a new sheet and back again for it to disappear, but it eventually comes back. Any help would be much appreciated. Kind…