-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
-
Setting up a recurring meeting notice
Can anyone tell me if it's possible to set-up a recurring weekly meeting within smartsheet for about 15 participants and include weekly agenda items? Thank you.
-
Smartsheet Reporting
Hey all - I am attempting to build individual reports for users in our account. I am having a bit of an issue setting up the parameters of the report as I'm not too sure how to build it out. Is reporting only pulled from the column sections? If so, if I needed to pull reporting for an item on a row, how exactly could I…
-
Separate effort and schedule for project planning
Hi folks, I am wondering people's experiences creating project plans that include separate estimating and tracking of effort versus schedule. A simple case has a task done full time, with full resourcing, with no delays or wait times. In this case, the Smartsheet "duration" works fine for both effort, duration, and…
-
Row Headers Not Aligned
Been using Smartsheet for about a year now in fully up to date Safari OSX 10.12.4 Suddenly yesterday the row headers do not align with their respective rows. Anyone else had this problem? Thanks in advance. David
-
Sights: Sheet Name Link issue
I am having an issue with my Sights where I have a Report Widget and within the report is the "Sheet Name" link. From the Sight, the first time I open, the Sheet Name link does not work. I have to first click in any other column to open the Report, and then the Sheet Name link will take me to the row on the Sheet. I can…
-
Multiple linking
I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row. I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not having any luck…
-
SUMIF
I am new to smartsheet so this may be a simple question. I want to sum up the total hours of a project based on the status of the column. I.e. total amount of hours complete, not started etc. The 2 colunms I am interested in are Status (on track, complete etc) and Duration I have tried this ...…
-
IFERROR -- Suppress Error Help Needed
Hello! I hope you're having a terrific day! I am looking for suggestions for using the IFERROR formula to suppress and error message. Here's the set-up: Columns: Planned Allocation = Out-of-Box Allocation column Planned Effort by Day = [Allocation] * 8 Duration = Out-of-Box Duration column Sum Planned Effort (Estimate) =…
-
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?