-
Sheet Summary Limit
Is there a hard limit to the number of fields we can add into the new Sheet Summary page?
-
Multiple People Assigned to row
When multiple people are assigned to a project in a row, on a test, only one person can update the row and others receive an error. They receive the following error on the update request email. Is the expected outcome is only one person can update the row? Should the "Update Request" allow the sending to all people on the…
-
Team Calendar on MS Teams
Hi. My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view? Thanks, Martha
-
NOt allowing me to add more rows
Good afternoon I am trying to get my smartsheet to 727 rows but it is stopping at 297? Very strange. Does anyone know why I cant add more rows?
-
Count of Cells less than a Date
Hello, I am working on a COUNTIF Formula which is not working. The whole formula which works: =SUMIF(Workstream:Workstream, ="Asset Mgmnt", [HIDE ME % COMP]:[HIDE ME % COMP]) / COUNTIF(Workstream:Workstream, ="Asset Mgmnt") Where Workstream is a drop-down column, and Hide Me % Comp is a % column. Focusing on the second…
-
Less Than Date Comparisons with Blank Cells
I have a column "Deliverable Past Due" that should return a Yes if any dates in the stated columns are less than today. The issue arises when many of the date columns are blank. The formula recognizes blank cells as being in the past and always returns a "Yes". I tried adding ISDATE to the statement, but then it always…
-
Automating a way of understanding time difference when start and end time are in the same column.
Hi everyone, We are looking at using a smartsheet solution to understand how much time employees on our production lines are spending working on certain lines. I created a separate sheet for each production line (we have 12 production lines) and I am using QR codes scanned via a smartsheet form (Quick for employees to…
-
Status Report based on certain conditions, i.e. dates, status etc
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
Inconsistent Date Options
Hi I recently came across 2 date-related options which look inconsistent within the app. Would be grateful if the smartsheet development team can address it soonest! The Inconsistency: In the Workflow-Automation we can set a Condition as <any date field> is not today; whereas in the Conditional Formatting dialog, we don't…