-
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) =…
-
Plus or Minus based on text
I am currently setting up an inventory management sheet that has a webform. I want to be able to have data updated based on one column. What I have is a column that is Shipped / Received. When completing the form, if the user chooses Shipped, the QTY column displays -10 and then takes this away from total stock on hand. If…
-
Changing Fiscal Year Start YEAR in Gantt Settings
It is possible to change the fiscal year to be the previous/current calendar year, vs the default of current/coming calendar year in the Gantt settings? My company uses a delayed April start. Thanks!
-
How to connection/Integration of Smartsheet with Outlook 2013 Desktop
Hi all, I'm looking for a clear tutorial or procedure to connect Smartsheet with Outlook 2013 Desktop. My Outlook is connected to an exchange server. I don't have any Office 365 login or paid account. I tried to install https://store.office.com/smartsheet-for-outlook-WA104379434.aspx?assetid=WA104379434# but a Microsoft…
-
Planview Integration
Hi, Has anyone tried or successfully pulled data from Smartsheet to Planview or any other PPM systems? If so I would be very interested to hear what the requirements were and how it was achieved. Many Thanks Paul
-
how to get a weighted average for a parent row, when children rows have "<" signs added to it
Hi there, I am currently working on a formula where the parent row will display the weighted average of children cells, based on the input weights. However, the problem I have at the moment is that there are numbers of cells with "<" sign added in front of the number and because of that, those data get ignored in the…
-
Invoke a template from a new record
Use case: I would like for a user to complete one form, and based on a value they select in the form, it logs that entry into a sheet, and also creates another sheet (a template) with a name taken from a cell in the form.
-
Printing info
Is there a way to print a list of all the people that I have shared a sheet with?
-
O365 Integration for unlicensed users
We have a Business plan with 15 licensed users, then will invite perhaps another 100 collaborators (unlicensed users) as part of the various projects across enterprise. All same organization. We are an O365 shop and have integrated all licensed users with O365. However, there does not appear to be anything but a static…
-
Getting value from Parent column
In the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". I was hoping to reference it by using =PARENT() Can someone show me how to do that? I have had no luck. =PARENT() provides a reference,…