-
calculate minutes a delivery is late
I am wanting to create a formula whereas I have an expected delivery time and actual delivery time and need to determine how many minutes the delivery was late. Does anyone know what formula to use in Smartsheet?
-
Primavera
Hello Everyone, Does Smartsheet can work or import primavera (enterprise project portfolio management software) ? Thanks for you help Olivier
-
Cell Linking Issues
Hi all, Is anyone else having issues with cell linking? I can no longer get it working.... It was all fine until about 4 weeks ago and now nothing will link?
-
SUMIFS based off Status and date?
I am building a counter for a team where they do a simple web form to say which task they did, and how many times they did it. There then needs to be a dashboard that then has a sum of that type of tasks completed during the current month, and the previous month (seperate). The FormData screenshot is the Grid that collects…
-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
-
Conditional Operations on Read Only Fields when Record is Modified
Scenario Two Fields Responsible Date Closed (read only) Requirements 1) When the record is updated, if Responsible equals "Closed", automatically populate Date Closed with TODAY() 2) When the record is updated, if Responsible does not equal "Closed", automatically populate Date Closed with blank What tools/methods can be…
-
Formula will function in Excel but not SmartSheet
For some reason I am having trouble getting this formula to function in SmartSheet (even though it works in Excel)... I am wanting to populate a "Y" in 'Valid Approval?' column only when one of the following 2 situations occur: 1) 'Primary Approval' says "Approved" AND 'Secondary Approval' says "Approved" 2) 'Primary…
-
Admin Access to Everything?
Is there a way that a Smartsheet Administrator would be able to gain access to all sheets/workspaces, even if not specifically shared to the admin? I am asking in terms of access controls, so we can put a control in place where the admin ensures no PI or Confidential informaiton is being added. Thanks!
-
Adding together multiple COUNTIFS?
Hey everyone. I'm trying to implement a formula that will allow me to reference two ranges from one sheet and follow the specified criteria that is given to them. My most recent attempt; =COUNTIFS({Unit_Type}, "CP2 - Double", {ACCS Overall}, [T2]26) + COUNTIFS({Unit_Type}, "CP4 - Double", {ACCS Overall}, [T2]26) +…
-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…