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 Alloca…
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 complet…
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!
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.…
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…
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 th…
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 fro…
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 a…
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…
