-
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?
-
Anything like pivot tables?
Is there anything similar to a pivot table capability in excel? I am trying to graph and analyze text - not numeric values. I figure I can make a secondary sheet in which I can do the formulas I need but I was trying to figure out a way to do this with minimal upkeep.
-
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…
-
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…
-
At-Risk Flag
Good Day All, I am wondering if there is a way to apply this format to my sheet. I want to be able to move a task to the executive dashboard automatically/ real time. For example, I want to be able to mark a task as at-risk and the task will move to the project dashboard automatically. I am still completely new at…
-
Multi-Select Feature Request
It appears there has been much discussion on this topic. Regardless of whether I'm using drop boxes or radio buttons, what is the status of a multi-select feature for web forms? An option to select one or more would be a nice enhancement! Smartsheet is cool, but a multi-select option would make it awesome! Thanks, George
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Dashboard - Source Reports
I'm new to Smartsheet. I'm trying to source a report to my Dashboard but it is only allowing me to select reports where I'm the Admin, but I'm the Owner. How can I go about adding reports that I'm the Owner of?
-
Parent Row Roll up using a specific text value
Community: I am piggy-backing off Nathan Skyers' request from November 24, 2016 1:13 pm, regarding Parent Row Roll up, as I need a very similar formula. Any help will be appreciated. Thank you, Sandy Is it possible to have a text value show in a parent row whether all statuses match my criteria OR if even one status…
-
Is it possible to count a Blank Cell only text is filled out in another cell?
Currently I'm using this formula =COUNTIF(Status:Status, "") to summarize all the blank cells in the Status column. The issue is that it also counts the Status cells that are just blank rows at the bottom of the sheet. Is there a way to count only the blank Status cells if there is also information populated in the…