-
Track time an item was open (active)
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? I have ideas but have found it makes most sense to run it by one of you first.…
-
Formula-Reference another sheet and see the column rather than(SheetName Range #)within the formula
Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Contact Month], "Jan", [Point Person]:[Point Person], "Mark") I have another sheet named "Summary - 2020". I want this exact…
-
Docs sheets in Smartsheet
Hi Are there any plans to introduce documents alongside sheets in Smartsheet? (like Google Docs and Google Sheets in Google, and Word and Excel in Microsoft) Thanks Cheers Richard
-
Formulas not showing in new rows
Hi, Not sure if this is a new issue but formulas in sheets aren't showing in new rows if there is a parent row below it. The first attachment shows how the sheet is setup and a number of columns have formulas in them. If I add a row between Test 3 and the Applications Confirmed parent row, it won't pull the formulas down…
-
Having problems embedding Smartsheet into new Google Sites
Hello, I am not able to add my DevOps course list attendees embed with a Smartsheet into the new Google Sites. I can easily embed other sites like soundcloud (works rather well). Please help - thanks.
-
Losing data when multiple users making changes at the same time
Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/reports respectively, I keep losing the data in my cells. How do I ensure to get their…
-
Compare the hours allocated to the hours actually worked, through timesheets
Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which projects. This time worked on projects would be compared to the time allocated to the…
-
Auto Assign Contact based on number of Open Tasks
Any help would be great. I have a form that dumps information into my sheet and would like to auto assign the task to a person/contact when it comes in. The Assignment is on a rolling basis. For example I have 4 people and as the work comes in it gets assigned to each one then starts again at the top of the list. Has…
-
Incomplete Tasks Count Multiple Criteria
I am trying to account for the number of incomplete tasks for Symbol column types. For example, our 'On Target" column uses the RYG Balls, and i am trying to pull back the number of incomplete tasks based on their color (red, green or yellow). This is the formula i have tried to use based on recommendations from this post…
-
How do I create an automatic updated sheet, that pushes information from other 2 smartsheets?
Team, I know you can do it. I have two databases (same structure, different information), but I need a third that consolidates the two previous. If anything gets added in the sources, it needs to be automatically added in the third. If anything gets UPDATED in the sources, the third needs to get updated.