-
Published User issue
The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info. I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tracked. How do I tell who this "published user" is, and why isn't the user's nme listed instead?
-
Counting criteria from a multiple drop-down column across multiple sheets
Hello, I'd like to show the number of tasks each person on my team is working on in a roll-up sheet. On all my project sheets, the 'Assigned To' column allows multiple names. When I attempt to aggregate the number of times a name appears in this column on all the referenced sheets, I get an incorrect number (no formula…
-
Row edit feature and sheets
Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by different areas. One of the areas prefers to work in the edit form to see the information vertically…
-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
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…
-
Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…
-
Prevent Formula Overriding
Hi there! I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox. The issue I'm having is that the formula erases if someone…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…