-
Adding Months to a Date
The Date formula allows addition but I get errors when I cross months by adding days or when I cross years by adding months. (Haven't tested years with adding days but that also crosses a month so I would get an error anyway. I need it to act like Excel and actually add a year for each multiple of 12 months in particular.…
-
Jira Connector - Start Up
Hello! Has anyone in the Smartsheet Community had any success getting Jira Connector up and running without the Launch Package? I reached out to our Customer Success Manager for assistance in getting the application up and running and was told I needed a Launch Package (i.e. you have to pay more to use the feature you paid…
-
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?
