-
Circular Reference Issue
So I have two fields I am trying to create a formula. The first field is Today's Date, in which it is autopopulated with the current date. I have a second field name Calendar End Date, I am trying to create the formula in this field. What I am trying to do is create a check that if Today's Date is greater than the Calendar…
-
Best time tracking software for Smartsheet?
Does anybody know of a good time tracking software that I can integrate with Smartsheet? Specifically, I am invisioning using a third-party time tracking software and be able to link the information (i.e. billing to date, hours, etc.) to my Smartsheet spreadsheet or Smartsheet Sight as a one stop shop with various other…
-
Key Command to Toggle/Cycle Through Open Sheets
Is this a thing or a plus one on a wish list? Much like toggling through open browser windows and all other apps etc I would like to be able to command tab through my open sheets. This might be a bit of a princess request but worth a shot.
-
Number of Days Ticket is Open
Hello all. I am a newbiw to Smartsheet, and I'm having trouble correctly adding a formula to one of my sheets. I have a repair sheet with a column that shows the date the ticket was created and a column that is labled number of days open. How can I have this column automatically display the number of days the ticket is…
-
several sheets, one update request?
Dear clever people of Planet SS I have created a Report to summarise the Milestones shared in several critical paths all of which are on seperate SS's. I now want to send out just one 'Update Request' to one person who has the same task across all Crit Paths, but when i do this I get a message that I can only send multiple…
-
Critical Path - Where Smartsheet fails - Need a Critical Path filter ASAP
I don't know about you, but I'm constantly being asked about speeding up our projects. Yet, Smartsheet actually hinders my ability to expedite projects. Before Smartsheet, one important method I used in MS Project was the following: 1) Filter to show only tasks on the critical path. (This usually reduces a 400-line project…
-
Critical Path Task w/o Critical Path Predecessor - Is this even possible?
I was reviewing the critical path of a project last week and saw something odd. Perhaps I'm mistaken, but I believe I saw a critical path task that had no critical-path predecessors. Is that even possible? The image below shows how I have a task in red color within the gantt, but no red lines leading to it. (I checked -…
-
Trying to Sum Checkboxes in a primary section of my sheet (not using CHILDREN)...
I'm working on a sheet that will provide me with a team breakdown and weekly breakdown based on checkboxed columns (to make it easier for the end users of the sheet). However, I can't get my formulas to work. (I'm certain that it's due to me being a Smartsheet novice.) I'm attaching a screen capture. Basically, I'm pulling…
-
Unable to Copy/Paste Between Different SmartSheets
Hi Everybody, I'm coming across an odd issue and have searched the help files and community discussions to no avail! Basically, I'm unable to copy cells from one sheet and paste it to another! Here's what I do: 1- I select the cell(s) I want to copy from the source sheet, right-click and select copy. (I've tried the CTRL+C…
-
Display Last Modified By field in both workspaces and lists for all sheets
We have had users request to see in the list and workspace views, the name of the user who edited a sheet last. Currently, we only see the owner and the date of the last update. This additional column would provide our users with a SharePoint 'like' experience that they are used to seeing.